How to send a POST request from Excel and get the response in the browser?

Question

Visual Basic

It is necessary to transfer the data from the excel sheet to the form on the server for further filling in the missing data and confirming the sending for processing.
There is a lot of data, a very long string is generated by the GET method, which leads to a runtime error.
IE is not used.
How can I form a POST and get the response in the browser?

Answer 1

stackoverflow.com/questions/158633/how-can-i-send-...

Answer 2

GET POST requests from VBA + IE
To work with IE from VBA:

Dim IE
    Set IE = CreateObject("InternetExplorer.Application")
 
    IE.Visible = True
 
    Dim strUrl as String
    strUrl = "http://..........."
    IE.Navigate strUrl 
 
    Do While IE.busy
        Application.Wait 1000
    Loop
    ...............

   IE.Quit
   set IE = nothing