Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
XL4 error executing Page.Setup function
Jim - Thanks for the suggestion but the slash is needed before the text (c#
syntax) to have double quotation marks around fontname and fontstyle. jack "Jim Rech" wrote: I didn't run your code but I think that the slash before the "Arial"'s should be inside the quotes. -- Jim "JackCali" wrote in message ... |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 | |
|
|
Similar Threads | ||||
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 |