Sending HTTP requests with VBA from Word

by

A potential alternative to avoid having to select the library is to use an object i.e.

Sub http()
Dim MyRequest As Object

    Set MyRequest = CreateObject("WinHttp.WinHttpRequest.5.1")
    MyRequest.Open "GET", _
    "http://www.google.com"

    ' Send Request.
    MyRequest.Send

    'And we get this response
    MsgBox MyRequest.ResponseText

End Sub

More Related Contents:

  1. Split Words in the comment text
  2. Get list of sub-directories in VBA
  3. How to insert text into Outlook email editor using VBA
  4. Getting the headings from a Word document
  5. What is behind this difference in parentheses effect in VBA?
  6. Speed up multiple replacement
  7. Repeating Microsoft Word VBA until no search results found
  8. Macro to update all fields in a word document
  9. To find and replace a text in the whole document in MS Word 2010 (including tables)
  10. Duplicate number and it value in column EXCEL [closed]
  11. Rearranging Excel Cell based on Value [closed]
  12. How do I get the old value of a changed cell in Excel VBA?
  13. Force a screen update in Excel VBA
  14. Find all matches in workbook using Excel VBA
  15. Create a new sheet for each unique agent and move all data to each sheet
  16. Set Auto Filtering multiple wildcards
  17. How to make Excel VBA variables available to multiple macros?
  18. VBA collection: list of keys
  19. Excel: macro to export worksheet as CSV file without leaving my current Excel sheet
  20. Determining whether an object is a member of a collection in VBA
  21. VBA ServerXMLHTTP https request with self signed certificate
  22. Determine whether user is adding or deleting rows
  23. What are possible suffixes after variable name in VBA?
  24. Removing the password from a VBA project
  25. Loop through Excel Sheets
  26. VBA Short-Circuit `And` Alternatives [duplicate]
  27. Call keyword – deprecated or not
  28. How can I automate Save as dialog box in IE11 using VBA?
  29. Partial Arrays by reference
  30. Conditional formatting using 3 conditions in Macro/VBA

Leave a Comment