.PageSetup: Any recent workarounds for the speed problem?
 

Office 2003.

When setting .PageSetup props, it's hopelessly slow. Something about multiple
calls to the print driver last I heard.

Been working around it with the Excel 4.0 macro kludge, but that doesn't seem to
support .FitOnPageTall or ...Wide.


Is there anything more recent to get around the performance issue?
--
PeteCresswell

.PageSetup: Any recent workarounds for the speed problem?
 

Is there anything more recent to get around the performance issue?

Maybe Excel 14 (version after 12). No joke. However a fast driver
alleviates much of the problem. Get the latest for your printer.

but that doesn't seem to support .FitOnPageTall or ...Wide.

It does. The thirteenth argument, scale, specifically. This sets it to 2
wide and 3 tall.

=PAGE.SETUP(,,,,,,,,,,,,{2,3})


PAGE.SETUP(head, foot, left, right, top, bot, hdng, grid, h_cntr, v_cntr,
orient, paper_size, scale, pg_num, pg_order, bw_cells, quality, head_margin,
foot_margin, notes, draft)

--
Jim
"(PeteCresswell)" wrote in message
...
| Office 2003.
|
| When setting .PageSetup props, it's hopelessly slow. Something about
multiple
| calls to the print driver last I heard.
|
| Been working around it with the Excel 4.0 macro kludge, but that doesn't
seem to
| support .FitOnPageTall or ...Wide.
|
|
| Is there anything more recent to get around the performance issue?
| --
| PeteCresswell

.PageSetup: Any recent workarounds for the speed problem?
 

Per Jim Rech:
PAGE.SETUP(head, foot, left, right, top, bot, hdng, grid, h_cntr, v_cntr,
orient, paper_size, scale, pg_num, pg_order, bw_cells, quality, head_margin,
foot_margin, notes, draft)

That's like *gold* for me....

Thanks!
--
PeteCresswell