Why does this macro take 5 seconds to execute?

[AHFoddeR]

Hey guys,

I've got some code to set the print area, set it to portrait, fit it to page and reduce the margins (see below). It takes about 5 seconds to run this code and I'm on a new desktop PC with loads of RAM. I've tried it on a couple laptops and it took 10-20 seconds.

Thoughts?

Code:

Please Login or Register  to view this content.

Thanks!

[Norie]

Try turning of printer communication before setting the page up.

Please Login or Register  to view this content.

[AHFoddeR]

Awesome mate. Got it down to about 1.5 seconds. Cheers! :D