macro timing

[VMan]

I am trying to create a macro that will execute several
steps of the macro, delay 5-10 seconds (or as long as it
takes to print a small report) than resume the macro. It
is critical with my design that the macro resumesafter
the report has printed. Thanks

 

[Dennis Schmidt]

Hi,

My name is Dennis Schmidt. Thank you for using the Microsoft Newsgroups.

An easier approach is to call your next report on the OnClose event of the
report. In other words, when report1 closes, it calls Report2, etc. This
can be done with either macros or code.

Trying to guess how long it will take a report to print is not a very exact
approach to your situation.

I hope this helps! If you have additional questions on this topic, please
reply to this posting.

Need quick answers to questions like these? The Microsoft Knowledge Base
provides a wealth of information that you can use to troubleshoot a problem
or answer a question! It's located at
http://support.microsoft.com/support/c.asp?M=F>.

This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.

Regards,
Dennis Schmidt
Microsoft Support