HTTPS POST in VBA for Excel
This project was awarded to vano101 for $36 USD.Get free quotes for a project like this
Project Budget$30-$100 USD
Using VBA in Excel, I need to be able to make an HTTPS POST request to a server.
Please note: I can already make a HTTP POST request using this code:
Set web = New WinHttpRequest
Const WinHttpRequestOption_EnableRedirects = 6
[url removed, login to view](WinHttpRequestOption_EnableRedirects) = True
[url removed, login to view] "POST", url, True
[url removed, login to view] "Content-Type", "application/x-www-form-urlencoded"
[url removed, login to view] "mydata=" & data
What I need is to be able to make an HTTPS request, i.e. with encryption.
I tried using "[url removed, login to view]" to specify a certificate for HTTPS, but was unable to make it work.
Please provide a working sample on how to make an HTTPS POST request in VBA.
Note: you don't need to use WinHttpRequest, that's just what I tried.
Please use any method which does the job, and provide a working sample plus installation instructions (if an external library such as CURL is needed, for example).
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online