Looks right to me.

Do you have the help file?

http://office.microsoft.com/en-us/ex...475331033.aspx

--
Jim
"(PeteCresswell)" wrote in message
...
| 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