S
sdg8481
Hi, i hope you can help.
Basically, from within a database i have a command (runapp macro) that opens
a specific excel workbook. This excel workbook has an autoexec macro in it so
that it runs when it opens and it takes about 40 seconds fro it to run
fully....My problem is that i want the runapp macro to do one more step (in
access) and then repeat its-self several times. However, ihaving trouble
because the access macro is trying to repeat BEFORE the excel one has
finished running.
Is there any ideas how i can stop this, somehow setting the access macro to
run only after the excel one has finished.
Hope this makes sense.
Thanks in advance
Basically, from within a database i have a command (runapp macro) that opens
a specific excel workbook. This excel workbook has an autoexec macro in it so
that it runs when it opens and it takes about 40 seconds fro it to run
fully....My problem is that i want the runapp macro to do one more step (in
access) and then repeat its-self several times. However, ihaving trouble
because the access macro is trying to repeat BEFORE the excel one has
finished running.
Is there any ideas how i can stop this, somehow setting the access macro to
run only after the excel one has finished.
Hope this makes sense.
Thanks in advance