Jon and Jim,

Stupid, short-sited me! I am just copying the worksheet and chartsheet
from a static Library file to my new current data file workbook. Why
was I trying to resize that in that current data file workbook. Idiot
(that'd be me). I just resized the buggers in the Library file to
biggest size possible. Only had to run that once. Never again.

May not work for your solutions since I am just copying the chartarea
to PPT and resizing the PPT page size to that size and then exporting
as .wmf

But is working for me right now.

On Sat, 06 Jan 2007 22:19:15 -0500, "Brian Reilly, MVP"
wrote:

Jon and Jim,
Thanks XL4 code is not going to work for me since this has to be
digitally signed and Verisign chokes on XL4 code.

I've got "most" of my charts not needing this so I'm restricting the
PageSetup code to the infrequently used charts. And as slow as it is,
it is still a heap lot faster then what they are doing now. I'll see
what I can do in next version (g).

Brian Reilly, PPT MVP

On Sat, 6 Jan 2007 10:57:43 -0800, "Jim Cone"
wrote:


As Jon suggested, I've also used the xl4 code to speed up pagesetup.
It is faster, but not dramatically so. The learning curve was steep for me.
For what it's worth, something you can try out is
eliminating the InchesToPoints conversion (72 points per inch) ...

.LeftMargin = 18
'and so on.