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

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

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