D
Dave Clark
Using Office 2000, I have created an Access database from which I want to
print a series of Word and Excel documents in a specific order to form a
client information package. Using the RunApp method or VBA code I am able to
open a document or spreadsheet, run a macro within it to print the page I
want, then close the application. The problem is that some pages format and
print more quickly than others, resulting in the pages printing in an
unpredictable order, sometimes with an "Access Denied" error. Is there a way
to pause execution until each macro has completed?
Any help you could provide would be greatly appreciated.
print a series of Word and Excel documents in a specific order to form a
client information package. Using the RunApp method or VBA code I am able to
open a document or spreadsheet, run a macro within it to print the page I
want, then close the application. The problem is that some pages format and
print more quickly than others, resulting in the pages printing in an
unpredictable order, sometimes with an "Access Denied" error. Is there a way
to pause execution until each macro has completed?
Any help you could provide would be greatly appreciated.