I am using Office 2003 on Windows XP.

Is there a way when opening a second file programmatically, to allow the
second file's ON_OPEN event code to finish before performing other tasks with
it from the first file?

e.g. User is in File1 and triggers File2 to open. File1 waits for File2's
ON_OPEN code to finish, then File1's code resumes...

I tried pausing my code in the calling file, but I still get "Application
Defined Error".

Any suggestions?