Open an Excel file from VB 6.0
I'd like to open a workbook but the compilation is not
completed because of the fouth line:
Dim xlApp As Excel.Application
Dim xlbook As Excel.Workbook
Set xlApp = CreateObject("Excel.Application")
Set xlbook = GetObject("C:\Siebel_macros_pp7Modif.xls")
The error message is: File or class name not found while
Automation operation
I'd like to be able to write this:
Workbooks.Open "C:\Siebel_macros_pp7Modif.xls"
Can you help me ?
Thanks.