Excel Application Posting via XML
Closed - This job posting has been filled.
We have an existing Excel Forms based application that includes an XML call to request and then receive data from a webservice
The application has been working without change for a number of months.
Yesterday the XML component of the application ceased working for all requests.
Through discussion with the source site it has been determined that the XML we are sending
is correctly formatted.
The problem seems to be with the creation of the HTTP object that is used to Post the XML request.
I need someone to review the current VBA code that is being used and to advise what needs to be changed
to make the XML requests work again.
I have posted below an excerpt of the code that I think is relevant and needs to be updated.
Please only respond if you have skills in this area.