P
Philosophaie
Dim XLApp As Excel.Application
Dim XLBook As Excel.Workbook
Set XLApp = CreateObject("Excel.Application")
'how do you word the opening of another preexisting file different than
'the current activesheet using Early binding? How do you link the two?
I tried:
'XLApp.Open ("c:\path\file.xls")
'XLApp.XLBook.Open ("c:\path\file.xls") they did not work
I also want to do the same for Access:
Dim AccApp As Access.Application
or something similar plus be able to manipulate the data from Excel to
Access would be nice.
Dim XLBook As Excel.Workbook
Set XLApp = CreateObject("Excel.Application")
'how do you word the opening of another preexisting file different than
'the current activesheet using Early binding? How do you link the two?
I tried:
'XLApp.Open ("c:\path\file.xls")
'XLApp.XLBook.Open ("c:\path\file.xls") they did not work
I also want to do the same for Access:
Dim AccApp As Access.Application
or something similar plus be able to manipulate the data from Excel to
Access would be nice.