HTTPS POST in VBA for Excel

This project was successfully completed by vano101 for $36 USD in 2 days.

Get free quotes for a project like this
Project Budget
$30 - $100 USD
Completed In
2 days
Total Bids
Project Description

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).

Completed by:
Skills Required

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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online