Open new session of excel

[hoops12]

Hi. i would like to open a file from a macro but have it open in a new instance of excel. Is this possible?

Thanks

 

[RobBroekhuis]

Yeah, you can create instances of Excel using:

dim xl as application
set xl=createobject("excel.application&quot
xl.visible=true
Rob

 

[hoops12]

Hi. I tried inserting this code but the file does not open up ina new excel application..just the one the macro is run from. Is something missing maybe? Thanks.

 

[combo]

Open the workbook using new instance and all should work:

Set xlWbk=xl.Workbooks.Open("Path\filename.xls&quot

combo