Autoexec macro

  • Thread starter Thread starter Rich Young
  • Start date Start date
R

Rich Young

I have created a macro that will copy a text file from a server location and
saves it as a different name to my local drive. I have a second macro that
imports the file into the db and runs a couple of queries. That all seems to
work fine when run separately. With that being said, I want to create a
autoexec macro that runs both macros upon opening the db. The problem is
that when run them in one macro by using the RunMacro command, I receive an
error. Apparently the second macro begins to run before the first one has
finished.

Does any one know how I can prevent the second macro from running until the
first is complete?

Thanks,
Rich
 
Try reversing the order of the macros in the autoexec. Import from server
first and second copy to local drive.
 
Back
Top