How to wait after printing with VBA? 
Author Message
 How to wait after printing with VBA?

Quote:

> I want to realize following:

> A two-sided document must be printed out three times on colorized paper.

> So I want to code a makro, that shows a Message Box "Please insert red
> paper!", then print three times the first page and after this shows again a
> Message Box "Please change the paper upside down and insert it again!" and
> print the second page three times.

> I've coded a simple makro yesterday, but this makro doesn't start printing
> immediately. It starts printing after both printing commands are sent and the
> makro has finished.

> CU!

> Ian

> http://www.*-*-*.com/
> http://www.*-*-*.com/

Use the MSGBOX command before each PRINT command.  A MSGBOX will display
your instructions and wait for the user to click its OK button before
the macro continues.

HTH.

David Gray-MVP



Wed, 29 Mar 2000 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. What is the command for WAIT and PRINT in VBA?

2. VBA command for WAIT and PRINT?

3. Close DOC... Wait Wait Wait

4. Waiting waiting waiting Power Point XP

5. Waiting, waiting, waiting.........

6. Waiting....waiting....waiting.

7. Macro / VBA - Wait for inactivity

8. making vba wait

9. VBA to wait 10 miliseconds

10. wait code snippet for VBA in Excel


 
Powered by phpBB® Forum Software © phpBB Group