none
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.


    Monday, December 03, 2012 11:48 AM

Answers

  • 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

    Tuesday, December 04, 2012 3:19 PM

All replies

  • 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.

    Tuesday, December 04, 2012 6:13 AM
    Moderator
  • 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

    Tuesday, December 04, 2012 3:19 PM
  • Hi Amber,

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

    /Przemek.

    Tuesday, December 11, 2012 11:05 AM