VBScript control Excel via COM works in Excel 2010 but NOT in Excel 2013

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

Answer 1

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

---

¯\_(ツ)_/¯

Answer 2

I should also note that, for most of us, Excel 2013 works with no new issues.

---

¯\_(ツ)_/¯