Opening new Excel app from VB

[RyanD]

Is it possible to open a new Excel app from a VB script and reference between the two?

i.e. instead of opening a new workbook, open a new Excel window and open the file in it and reference between the file that opened the new window and the newly opened window.

Thanks,

Ryan

 

[Ivan F Moala]

On 2002-09-23 17:41, RyanD wrote:
Is it possible to open a new Excel app from a VB script and reference between the two?

i.e. instead of opening a new workbook, open a new Excel window and open the file in it and reference between the file that opened the new window and the newly opened window.

Thanks,

Ryan

Ryan
Have a look @ CreateObject

eg
Dim xlApp As Object ' Declare variable to hold the reference.

Set xlApp = CreateObject("excel.application")