locked
VBScript control Excel via COM works in Excel 2010 but NOT in Excel 2013 RRS feed

  • Question

  • Hi All,

    Does anyone know of any reason why VBscript that using COM to connect to Excel and perform some basic functions would stop working when I move to Excel 2013?  I have several VBscripts that run perfectly in 2010 but I get the following error when I try using Excel 2013:

    OLE error code 0x80070001:Unknown COM status code

    I can't even get a very simple test VBscript to open a new workbook in Excel.

    Has anyone come across this error or have any suggestions regarding the cause and/or resolution?

    Thanks in advance!

    John

    • Moved by Bill_Stewart Monday, March 2, 2015 8:44 PM Unanswerable drive-by question
    Thursday, January 22, 2015 9:47 PM

All replies

  • We cannot tell unless you post an example of the code the causes this error along with the complete error message.


    ¯\_(ツ)_/¯

    Thursday, January 22, 2015 11:53 PM
  • I should also note that, for most of us, Excel 2013 works with no new issues.

    ¯\_(ツ)_/¯

    Thursday, January 22, 2015 11:54 PM