Printing Speed

C

Charles

Hi
I am using a macro in Excel 97 to move fields from a record to a print
template on a second sheet and then print it using the
'ActiveSheet.PrintOut' function.
The macro loops through 100 records, scheduling the reports but takes
forever to print them.
There was a post some time ago with a similar problem and the suggestion was
to disable the refresh screen or something like that.
Any suggestions please.

Charles
 
N

Nick Hodge

Charles

If that will fix it then use

Application.ScreenUpdating = False

at the start of you code and the same but False at the end.

Printing in Excel uses a lot of interaction with the print driver however,
that may be more your issue

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
D

David McRitchie

Since printing is involved there is an additional item concerning printing:

If you are inserting/deleting hiding/unhiding rows or changing page layout in any way. You might notice that slowing down only
occurs after Print Preview for Instance. Turn off PageBreaks. (Tom Ogilvy, 2000-11-28) -- more detail on page breaks
http://www.mvps.org/dmcritchie/excel/pagebreaks.htm

Turn off manually with Tools --> Options --> View --> (uncheck) Page Breaks,
or in VBA with
ActiveSheet.DisplayPageBreaks = False


Still another item that will speed up most macros, unless you
manage to write a macro without any loops, is to turn off
calculation.
http://www.mvps.org/dmcritchie/excel/slowresp.htm
 
Top