Setting page properties for all sheets in Excel using OLE

[weathejx]

using OLE ive created a work book in excel that has multiple sheets of information. i want to format all of the sheets page properties (Landscape, print zoom, header/footer, etc). the only way that i have come across to do this is to go to each sheet, change change all the properties and then move to the next sheet. the problem with this is that it is VERY time consuming. just changing all the properties adds about 4minutes or so onto the runtime.

anyone have an idea on how to change the page properties of ALL the pages? ive tried using a template excel file but only the first sheet is formatted.

thanks

x

 

[chazoid]

the FillAcrossSheets method might do what you want. I think you have to set the formats on the first sheet, then you can apply those to the rest.. I've never tried this, so I could be wrong.. just a suggestion.