Setting the Headers and Footers in Excel 2007 when exporting Information from Cobol program

M

Matt

I am getting the error "Unable to set the LeftHeader property of the
PageSetup Class" when I try to export data to Excel 2007.

Here is the code I am using:

MODIFY WORKSHEET @PageSetup::LeftHeader = GUI-HEADER-TITLE.

I have also tried creating a PageSetup object and then modifying that
object, but that also gives me the above error when the exporting to
Excel.

The above code does work in Excel 2003. But I am not exactly sure
what I need to go to get the Headers and Footers to work in Excel
2007.

Anyone have any ideas?

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

2003->2007"unable to set the Left header property of the PageSetup 2
VSTO C# add in Outlook.Appointment error 0
Update Headers & Footnotes from User Form 13
Setting LeftHeader / CenterHeader 3
Page setup error after moving sheet tabs 3
Problems starting Word from Excel VBA 3
Using VBA to set Headers and Footers with Font and Fontsize parameters 7
macro that adds left and right footers 4

Top