Excel Sheet Setup via VB6

I am exporting to Excel and am running the following code to setup the page layout

This takes 9 seconds on a P4 3.0 with 2GB Ram Excel 2003

Should it take so long ?
Can it be optimised ?


Code:

Please Login or Register  to view this content.

XL can be very slow when dealing with page setup etc... given round trips to printer driver... have a read through the below and see if that gives you some pointers:

http://www.mcgimpsey.com/excel/udfs/pagesetup.html

EDIT:

Also from Googling I note Colo (MS Excel MVP) suggests an alternate approach using SendKeys, see: http://puremis.net/excel/code/039.shtml