Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm in MS Access VBA, trying to work around the very slow access to .PrintSetup
in an Excel doc. I've been using the old Excel 4 macro "PAGE.SETUP", but suddenly it's gone goofy on me - not applying .PaperSize for one. My first guess is that I've fat-fingered the code and don't have the parms lined up right. Tried a little Googling, but couldn't find any docs for that macro. Can anybody say if this parm list looks right? 21 parms: -------------------------------------------- ' PAGE.SETUP(HeaderText, ' FooterText, ' LeftMargin, ' RightMargin, ' TopMargin, ' BotMargin, ' PrintHeadings, ' PrintGridLines, ' CenterHorizontally, ' CenterVertically, ' Orientation, ' PaperSize, ' scale, ' FirstPageNumber, ' pg_order, ' bw_cells, ' PrintQuality, ' HeaderMarginInches, ' FooterMarginInches, ' PrintComments, ' DraftPrintingMode ' ) ------------------------------------------------ -- PeteCresswell |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Page layout - page setup - items disabled | Excel Discussion (Misc queries) | |||
FORMAT EXCEL WORKBOOK (PAGE SETUP) ALL AT ONCE INSTEAD OF BY PAGE | Excel Discussion (Misc queries) | |||
HOW DO I SETUP A PAGE IN EXCEL TO GIVE TOTALS TO ANOTHER PAGE | Excel Worksheet Functions | |||
Under Page Setup the page option of Ledger - for Office XP | Excel Discussion (Misc queries) | |||
page setup with Excel4 & Waiting Form | Excel Programming |