System error: -2146697208 - when trying to initialize SOAP client session in Excel 2010

Question

Hi All,

Can anyone guide me through this? I have Excel 2003 file with macros behind, which consume SOAP ASMX web service with MsSoap Type Library 1.0. Now when I give it a try in Excel 2010, it fails to work. All references are ok, and vba project compile w/o issues.

I am getting this, when trying to do mssoapinit:

WSDLReader: XML Parser failed at linenumber 0, lineposition 0, reason is: System error: -2146697208.

Does anyone know where I can find description for this mysterious error number?

Great thanks in advance,

Przemek.

Answer 1

Hi Przemek,

Thanks for posting in the MSDN Forum.

I will involve some experts into your thread to see whether they can help you. There might be some time delay, appreciate for your patience.

Have a good day,

Tom

---

Tom Xu [MSFT]
MSDN Community Support | Feedback to us
Develop and promote your apps in Windows Store
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 2

Hello,

Office 2010 requires MSXML6. Please see the article below.

Changes in Office 2010 (for ITPros)
http://technet.microsoft.com/en-us/library/cc178954(v=office.14).aspx

Support for Microsoft XML Parser 5
Office 2010 does not support Microsoft XML Parser 5 (MSXML5). Existing solutions will not create an instance of MSXML5 objects when they are loaded by Office 2010. Migrate code to Microsoft XML Parser 6 (MSXML6) or to managed code that uses the .NET Framework.

Changes in Excel 2010 (for ITPros)
http://technet.microsoft.com/en-us/library/cc179167(v=office.14).aspx

MSXML5

MSXML5 is not supported in Excel 2010. Users will receive a runtime error if they attempt to run an Excel extensibility solution created by using MSXML5. Migrate code to MSXML6 or to managed code that uses the .NET Framework.

Amber

Answer 3

Hi Amber,

sorry for dull response. It worked for me, thanks!

/Przemek.