HTTPS POST in VBA for Excel

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

Beceriler: Excel, Visual Basic

Daha fazlasını gör: vba http post, vba https, vba post, http post excel, vba setclientcertificate, excel vba post, http post vba, vba post request, http request vba sample, post https request excel, vba curl, vba post url, winhttprequest option vba, excel https post, excel https, web request vba, vba https post, excel vba https post request, excel vba post request, setclientcertificate vba, excel vba winhttprequest post, https excel vba, excel vba https, vba post https excel, winhttprequestoption_enableredirects

İşveren Hakkında:
( 19 değerlendirme ) Biella, Italy

Proje NO: #4411104



Hello. I have developed C++ code that sends something through HTTPS. I would able to compile it in ActiveX (or COM object) in order to call it from VBA. What do you thing about this solution? Also, I

%selectedBids___i_period_sub_7% gün içinde 36%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(101 Değerlendirme)

Bu iş için 3 freelancer ortalamada $39 teklif veriyor


Hi, I can do it, please check my PM for details. Thanks.

in %bids___i_period_sub_35% gün içinde50%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(4 Değerlendirme)

Se potessi avere la macro excel potrei provare.. In ogni caso guarda il PM. Ciao

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)