Excel macro & multiple users
 

I've used a macro to automate functions in a purchase order form that
our company uses. The macro opens a template (VBAProject1) and saves it
to %temp% for further processing. Once the user finishes completing the
form I invoke a macro from a separate project (VBAProject2) which
removes all modules and objects from VBAProject1temp, saves it on the
server then deletes the temp file. The last thing VBAProject2 does is
to display a message box asking the user if they want to create another
purchase order. If yes it starts VBAProject1, otherwise it exits. My
problem is that while this message box is being displayed another user
cannot start VBAProject1. It appears to me that VBAProject1 should only
be active only for the brief moment that it's saving a copy of itself in
%temp%. So why is it locked while the message box from VBAProject2 is
waiting for a response?

TIA!
BrianG



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!