Open Excel in Two Different Threads

[Jeffrey Mahoney]

I have macros that run Scripts in SAP. Some of these SAP reports take 5 to 10 minutes. When the script is running, Excel locks up and I have to wait for it to finish I would like to open a separate version of Excel and run the scripts from there so I can continue my other work. Is this possible?

Jeff

 

[Artik]

1. Windows + R and in the window type

excel /x

2. click on the Start menu, find the Excel icon in the list, before you click on the Excel icon to launch it hold down the LeftALT key.

Artik

 

[Jeffrey Mahoney]

Most excellent Artik, thank you. Oh, BTW, you have a bug on your picture

So I thought I would try to open the new thread using vba, and it works. Open new thread, run SAP macro in new thread. TaDa!

Sub NewExcelThread()
  Shell "Excel /x", vbNormalFocus
End Sub