View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
(PeteCresswell) (PeteCresswell) is offline
external usenet poster
 
Posts: 139
Default Excel4 PAGE.SETUP?

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