I have a VB6 program which creates an excel workbook with
multiple worksheets in which data streams are inputted. I
would like to open an existing workbook, instead of
creating a new one, to do the same procedure. I am having
problems using Get Object to do so. Any help is much
appreciated.
Thanks,
Martin

Sub XL_Automation()
Dim xlsApp As Excel.Application
Set xlsApp = CreateObject("Excel.Application")
xlsApp.Visible = True
xlsApp.Workbooks.Open "c:\book1.xls"
'continues...
End Sub


--
Jim Rech
Excel MVP