VBA ServerXMLHTTP https request with self signed certificate

by

I used to have this problem for a while, and I only managed to get past it thanks to this:

Set objHTTP = CreateObject("MSXML2.ServerXMLHTTP")
objHTTP.SetOption 2, objHTTP.GetOption(2)
objHTTP.Open "POST", "https://invernalia.homelinux.net", False, "user", "password"
objHTTP.setRequestHeader "User-Agent", "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)"
objHTTP.send ("")

I have found this here setOption Method and getOption Method

Here in this code I have just used SXH_SERVER_CERT_IGNORE_ALL_SERVER_ERRORS but you can try with others more specific:

  • SXH_SERVER_CERT_IGNORE_WRONG_USAGE
  • SXH_SERVER_CERT_IGNORE_CERT_CN_INVALID
  • SXH_SERVER_CERT_IGNORE_CERT_DATE_INVALID
  • SXH_SERVER_CERT_IGNORE_UNKNOWN_CA

More Related Contents:

  1. to make this code simpler
  2. Does VBA have Dictionary Structure?
  3. Get reference to additional Inbox
  4. How to create and write to a txt file using VBA
  5. Save text file UTF-8 encoded with VBA
  6. Outlook VBA – Run a code every half an hour
  7. Excel VBA deleting rows in a for loop misses rows
  8. Can I iterate through all Outlook emails in a folder including sub-folders?
  9. Download attachment from Outlook and Open in Excel
  10. What is the most efficient/quickest way to loop through rows in VBA (excel)?
  11. Embed picture in outlook mail body excel vba
  12. How to check for empty array in vba macro [duplicate]
  13. Where does VBA Debug.Print log to?
  14. How do I display a messagebox with unicode characters in VBA?
  15. VBA Adding a class to a collection [duplicate]
  16. MS Access VBA Error: Run time error ’70’ Permission Denied
  17. What is the function of FormulaR1C1?
  18. Rounding a number to the nearest 5 or 10 or X
  19. Change color of certain characters in a cell
  20. How to insert text into Outlook email editor using VBA
  21. MS Access: how to compact current database in VBA
  22. Want VBA in excel to read very large CSV and create output file of a small subset of the CSV
  23. How do you extract email addresses from the ‘To’ field in outlook?
  24. Can I Get the Source Range Of Excel Clipboard Data?
  25. Using visual basic to access subfolder in Inbox?
  26. How to create dynamic variable names VBA
  27. Read VBA macros (or vbaProject.bin) of an Excel file without opening it in MS Excel [closed]
  28. simple vba code gives me run time error 91 object variable or with block not set
  29. How do I get a list of unique values from a range in Excel VBA?
  30. How to get selected value in multicolumn listbox

Leave a Comment