View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JackCali JackCali is offline
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