AutoPrint using Macro

[Launchnet]

Hi Rylo (If you see this) I've talked to you before.

Problem described below

Please Login or Register  to view this content.

'THE FOLLOWING CODE PRODUCES ERROR AND DOES NOT PRINT

Please Login or Register  to view this content.

'I HAVE CLEARED THE PRINT AREA FOR THIS PAGE AND RE=ENTERED IT AND IT STILL PRODUCES AN ERROR.
'CAN ANYONE GIVE ME SOME IDEA?

'THANKS
'MATT @ LAUNCHNET

[Launchnet]

Just split the macro into 2 macro's, as I felt that my printer might be running out of memory.

Sure enough, both work fine.

NEW QUESTION . . .

Is there a line of code that I can place in the macro that will pause the macro for let's say 15 seconds, so that my cheap slow printer can open up some memory?

Thanks for a reply

Matt @ Launchnet

[Paul]

Hi Launchnet,

You can use the Application.Wait command to 'pause' the macro, like so:

Please Login or Register  to view this content.

That will force the macro to wait 15 seconds before executing the next line of code.

[Launchnet]

Hi - Sorry I couldn't get back to you sooner. I just got home from Bible Study.

Your code works perfect. Only 1 macro now.

Many thanks.

Matt