09-14-2010, 05:59 AM
When checked 'run in separate process', it inserts " /exe 1" at the beginning of the macro.
Then, when you run the macro, it creates and runs YourMacroName.exe file in My Documents\My QM folder.
How it works if you doubleclick the exe file in Windows Explorer?
--------
Make sure that Excel runs not as administrator.
Also, Excel must be running in the same user account as your exe. Look in Task Manager, maybe they run in different accounts.
Then, when you run the macro, it creates and runs YourMacroName.exe file in My Documents\My QM folder.
How it works if you doubleclick the exe file in Windows Explorer?
--------
Make sure that Excel runs not as administrator.
Also, Excel must be running in the same user account as your exe. Look in Task Manager, maybe they run in different accounts.