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.)
PaulC wrote:
Up until now I have been using Windows NT4 & Excel97. I have a workbook
with various macros to print out different reports from selected ranges
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 (HP
Laserjet 1100) is activated.
We are changing to XP Prof and Excel2003. I have tried the same macros
with XP/2003 and there is now a 40+ second delay after each
Selection.PrintOut line.
Does anyone have any idea why this should be, and any suggestions for
fixing it.
Many thanks in advance,
Paul
--
PaulC
------------------------------------------------------------------------
PaulC's Profile: http://www.excelforum.com/member.php...fo&userid=7563
View this thread: http://www.excelforum.com/showthread...hreadid=261580
--
Dave Peterson