Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
Access
3rdpartyusrgrp
access
activexcontrol
adp.sqlserver
commandbarsui
conversion
dataaccess.pages
developers.toolkitode
devtoolkits
externaldata
forms
formscoding
gettingstarted
internet
interopoledde
macros
modulescoding
modulesdaovba
modulesdaovba.ado
multiuser
odbcclientsvr
queries
replication
reports
security
setupconfig
tablesdbdesign
  
 
date: Tue, 5 Aug 2008 10:38:01 -0700,    group: microsoft.public.access.macros        back       


Macro to wait until an excel spreadsheet macro has finished runnin   
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
date: Tue, 5 Aug 2008 10:38:01 -0700   author:   sdg8481

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us