Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Access Macros > Macro to wait u...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 1 Topic 5699 of 5947
Post > Topic >>

Macro to wait until an excel spreadsheet macro has finished runnin

by =?Utf-8?B?c2RnODQ4MQ==?= <sdg8481@[EMAIL PROTECTED] > Aug 5, 2008 at 10:38 AM

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
 




 1 Posts in Topic:
Macro to wait until an excel spreadsheet macro has finished runn
=?Utf-8?B?c2RnODQ4MQ==?=   2008-08-05 10:38:01 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Fri Nov 21 14:31:46 CST 2008.