[Migrated content. Thread originally posted on 10 April 2007]
I am exporting data to Excel using the Application, Workbook, Worksheet and Range objects. I am having a problem trying to get the page number to display properly when I print from Excel. Throwing all the information from my program to Excel is fine and I am able to set the LeftHeader, LeftFooter and CenterFooter with the correct information, and I need to set the RightFooter so the Page Number will print out, but I cannot get it to work.Does anyone have any ideas?
I looked at the Headers and Footers view in Excel and when I click on Custom Footer, it allows me to put "&[Page]" into the Right Section and I tried modifying my worksheet, in my program, using "&[Page]", but when I Export my data to excel and print out the spreadsheet, I get "Page]" where the page number should be.
