Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Under Page Setup the page option of Ledger - for Office XP | Excel Discussion (Misc queries) | |||
Excel page setup Sheet Print Cells Error As... | Excel Discussion (Misc queries) | |||
Error on ExecuteExcel4Macro Page.Setup | Excel Programming | |||
ExecuteExcel4Macro Page.Setup Runtime Error | Excel Programming | |||
Error 1004 - unable to set the orientation of the page setup class | Excel Programming |