LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Page layout - page setup - items disabled Bill D - Hubbard & Co Excel Discussion (Misc queries) 6 February 2nd 10 04:34 PM
FORMAT EXCEL WORKBOOK (PAGE SETUP) ALL AT ONCE INSTEAD OF BY PAGE fred Excel Discussion (Misc queries) 1 August 11th 08 04:54 PM
HOW DO I SETUP A PAGE IN EXCEL TO GIVE TOTALS TO ANOTHER PAGE Randy Excel Worksheet Functions 1 February 8th 07 06:15 PM
Under Page Setup the page option of Ledger - for Office XP Turbo Excel Discussion (Misc queries) 2 September 27th 06 02:46 AM
page setup with Excel4 & Waiting Form Liedson31 Excel Programming 1 June 8th 05 06:46 PM


All times are GMT +1. The time now is 10:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"