Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel4 PAGE.SETUP?
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel4 PAGE.SETUP?
Per Jim Rech:
Looks right to me. Do you have the help file? http://office.microsoft.com/en-us/ex...475331033.aspx No, I didn't. Thanks for the link. Just downloaded/installed it. Now I've got to figure out how to get to it.... not having any other Office 2k components installed. -- PeteCresswell |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel4 PAGE.SETUP?
go to it in windows explorer and double click on it.
-- Regards, Tom Ogilvy "(PeteCresswell)" wrote in message ... Per Jim Rech: Looks right to me. Do you have the help file? http://office.microsoft.com/en-us/ex...475331033.aspx No, I didn't. Thanks for the link. Just downloaded/installed it. Now I've got to figure out how to get to it.... not having any other Office 2k components installed. -- PeteCresswell |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel4 PAGE.SETUP?
Further to Tom - I created a desktop shortcut for opening the XL4 macros
help file. -- Jim "(PeteCresswell)" wrote in message ... | Per Jim Rech: | Looks right to me. | | Do you have the help file? | | http://office.microsoft.com/en-us/ex...475331033.aspx | | No, I didn't. Thanks for the link. | | Just downloaded/installed it. | | Now I've got to figure out how to get to it.... not having any other Office 2k | components installed. | -- | PeteCresswell |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel4 PAGE.SETUP?
Per Jim Rech:
Further to Tom - I created a desktop shortcut for opening the XL4 macros help file. Thanks. Took awhile for it to dawn on me that it was "XLMACRO.CHM" in the Office\1033 dir. I just copied it to a "$Tools" folder that I keep in my development drive. -- PeteCresswell |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |