Multiple Instance of appliction
I currently have several files in my XLSTART folder that I use all the time.
Normally there is only one instance of EXCEL running. However, I do
periodically have an instance open via automation to run a a couple macros
then close out again. When the second instance opens, it wants to reload all
those files in the XLSTART. Is there a way to prevent this from happening?
When it trys to load them, I get the file in use error dialog boxes asking
for Read/Only or Notify.
|