Hi<BR><BR>Not sure if I have the correct forum and I have tried tek-tips as well but you have been helpful in the past. <BR><BR>Basically through ASP I open a workbook and add some sheets to it. I then want to add a footer for each of the sheets. Ideally I would like one footer for the workbook but I am not sure I can do that. I am getting the following message when I do.<BR><BR>Unable to set the LeftFooter property of the PageSetup class<BR><BR>the line of code is <BR><BR>wb.worksheets(1).PageSetup.LeftFooter = "Page &P of &N Printed &D &T"<BR><BR>Has anyone tried this before, know if it can be done.<BR>Thanks,<BR>Sinead