Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,290
Default Error on ExecuteExcel4Macro Page.Setup

Claus,
Understanding and using the xl4 code for page setup was a
major undertaking for me. I won't admit how long it took.
I don't think it can be learned without the xl4 function help file...
http://makeashorterlink.com/?B24052ACB

"&nn Prints the characters that follow in the specified font size."
I have used it this way...

Dim nn as Long
Dim Head as String
dim strNumber as String
nn = 12
strNumber = "&" & nn
Head = """&L" & strNumber & "Printed on &D" & "&C" & strNumber & _
Application.OrganizationName

also...
the formatting codes for xl4 and later versions of Excel appear to be the same...

Dim WordToUse as String
WordToUse = "Never Upgrade"
WordToUse = "&""ChevaraOutline,&B""&20" & WordToUse
That should change the font to ChevaraOutline, make it bold and size 20.

Regards,
Jim Cone


"Claus" wrote in message ...
Hi again
I can't control the font.
Is is possible ?
How ?
Regards,
Claus


Claus,
Not much help here, just some comments/questions...
The John Green code (as is) works for me in xl2002.
The xl4 code is very sensitive and all of the quote marks are required.
Are you using Option Explicit and does your code compile?
Arguments for margins are always in inches, regardless of your country
setting.
Regards,
Jim Cone
San Francisco, USA


Reply
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
Excel page setup Sheet Print Cells Error As... tikchye_oldLearner57 Excel Discussion (Misc queries) 2 May 16th 06 04:29 PM
ExecuteExcel4Macro Page.Setup Runtime Error Geoff Martin Excel Programming 1 January 27th 04 01:44 PM
Error 1004 - unable to set the orientation of the page setup class E Sullivan Excel Programming 4 October 27th 03 02:31 PM


All times are GMT +1. The time now is 12:15 AM.

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"