.xlsm file to always open in new excel instance

[vineet78]

Hi

i have a project .xlsm file which opens in existing Excel sessoin.
I use excel 2010

Problem is that if there are already open excel files, this .xslm file runs very slow.
cAN I build a code within this file which will open this file in a new session only.

Many thanks in advance.

Regards
Vineet

 

[vineet78]

Hello

I am using the below code now but it is opening separate file and that also read only.
Then it is taking 30 seconds to make file available for read/write.

Dim xlApp As Application
Dim filepath As String
Dim filename As String
filepath = ActiveWorkbook.Path
filename = ActiveWorkbook.Name
Set xlApp = CreateObject("Excel.Application")
xlApp.Visible = True
xlApp.Workbooks.Open filepath & "/" & filename
ActiveWorkbook.Save
ActiveWorkbook.Close