Get Object

  • Thread starter Thread starter Martin
  • Start date Start date
M

Martin

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
 
Back
Top