I'm using the new webservice function in excel 2013. I have a problem that when the return message from the service is above a certaian size. The call in excel craps out. I can make the same call from a web browser without any problems.
Are there any work arounds to this?
Dim sResultXML As String
sResultXML = Application.WorksheetFunction.WebService(sURL)
GetXMLResults = sResultXML
Error # 1004: Unable to get the WebService property of the WorksheetFunction class
Bookmarks