>I am creating a spreadsheet with the following code:
>
>ExcelObj = CreateObject('Excel.Application')
>ExcelObj.Visible = .T.
>ExcelObj.Workbooks.Add
>ExcelBook = ExcelObj.ActiveWorkbook
>ExcelSheet = ExcelBook.Activesheet
>
>I have no problem filling the spreadsheet, but I am having a hard time finding out how to put in the title of the spreadsheet. In excel, it would be under Page Setup/Custom Header. Can anyone help with the syntax?
>
>Thanks,
>
>Mark

Mark,

WITH ExcelObj.ActiveWorkbook.ActiveSheet.Pagesetup
.LeftHeader = "MyLeftHeader"
.CenterHeader = "MyCenterHeader"
.RightHeader = "MyRightHeader"
ENDWITH

The same goes for footer.

Nick