I am creating some code that runs in Excel using VSTO. I am trying to get
some xml from a webservice, using the following code:
GBWPipeline.PipelineService pipeline = new GBWPipeline.PipelineService();
string xml = pipeline.GetOfferSale(OfferSheetId, CustomerId).GetXml();
I get a "There is an error in XML document. (1, 220)" message. If I execute
the same method from WebServiceStudio, it works fine (using the same values
for the parameters) and returns the xml that I expect (and doesn't complain
about any errors). It also works in a normal WinForms application. It is
only inside Excel that it fails.
I have other Excel workbooks that also retrieve xml from webservices and
they work. Thanks for any suggestions.
Colin