Method 'Open' of object 'Workbooks' failed.

M

Mike

Please give me a hand.

The source code in VB 6 is something looks like as
follow:

Dim ExcelObj As Excel.Application
Set ExcelObj = CreateObject("Excel.Application")
ExcelObj.Workbooks.Open App.path & "\" & "myTable.xls"
...

It works well on any combining environment between:
Windows 98/2000/XP and Excel 97/2000/XP, except Office 97
and Windows XP.
When running on the Office 97 and Windows XP, the problem
is "Method 'Open' of object 'Workbooks' failed".

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Method 'Open' of object 'Workbooks' failed. 1
Runtime error 2147467259 (80004005) method return address of object envelope failed 2
Using Excel from Access 0
method 'add' of object 'workbooks' failed 3
Method 'Open' of object 'Workbooks' failed 23
Method "Method 'Open' of object 'Workbooks' failed 2
trying to email workbook from VB6, getting error 1004 2
method add of workbook fails 0

Top