View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tim Rush Tim Rush is offline
external usenet poster
 
Posts: 27
Default 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.