Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default XL4 error executing Page.Setup function

I tried to use XL4 Page.Setup function to speed up setting properties and I
received an error when trying to apply a font and font style to the header or
footer text. I'm using C# .NET 2.0 to make the call into Excel. Can someone
tell me what I am doing wrong with the below Page.Setup function?

"PAGE.SETUP(\"&L&\"Arial, Bold\"&14U_LEVEL&R&\"Arial,
Bold\"&14U_LEVEL\",\"&L&\"Arial, Bold\"&14U_LEVEL&R&\"Arial,
Bold\"&14U_LEVEL\",,,,,,,,,,,,,,,,0.025,0.30,,)"

Error message received:
The formula you typed contains an error. For information about fixing
common formula problems, click Help. To get assistance in entering a
function, click OK, then click Function on the Insert menu. If you are not
trying to enter a formula, avoi...

If I remove the font and font style, then the function executes successfully.
"PAGE.SETUP(\"&L&14U_LEVEL&R&14U_LEVEL\",\"&L&14U_ LEVEL&R&14U_LEVEL\",,,,,,,,,,,,,,,,0.025,0.30,,)"

Thanks,
Jack

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
Under Page Setup the page option of Ledger - for Office XP Turbo Excel Discussion (Misc queries) 2 September 27th 06 02:46 AM
Excel page setup Sheet Print Cells Error As... tikchye_oldLearner57 Excel Discussion (Misc queries) 2 May 16th 06 04:29 PM
Error on ExecuteExcel4Macro Page.Setup Jim Cone Excel Programming 3 September 13th 05 05:06 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:09 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"