Slow Printing using VBA after changing to WinXP/Excel2003

  • Thread starter Thread starter PaulC
  • Start date Start date
P

PaulC

Up until now I have been using Windows NT4 & Excel97. I have a workboo
with various macros to print out different reports from selected range
on spreadsheets using for example:

Range("B2:X26").Select
Selection.PrintOut Copies:=1, Collate:=True

This works fine and takes about 3 seconds before the Printer (H
Laserjet 1100) is activated.

We are changing to XP Prof and Excel2003. I have tried the same macro
with XP/2003 and there is now a 40+ second delay after eac
Selection.PrintOut line.

Does anyone have any idea why this should be, and any suggestions fo
fixing it.

Many thanks in advance,

Pau
 
Just a guess--maybe it's time to get a new driver from HP's web site.

(Maybe there's a difference between the NT driver and XP driver.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

setting print ranges to print based on option 4
Print number of copies box 5
How to optimize and improve that code ? 7
VBA Code printing problem 3
Macro Print Range Problem - Rows Cut Off (Upgraded From Excel 2003 to2007) 1
How to pool Print Jobs 1
Using cell row # in a VB macro 2
printing to a computed column 2

Back
Top