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

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.