Hi

Can anyone tell me how to create a header and a footer in excel from a
vb project. I can create the workbook and add text etc to the sheets
but i dont know how to create a header & footer.

Please help

Thanks

ActiveSheet.PageSetup.CenterHeader = "yourCheader"
ActiveSheet.PageSetup.RightHeader = "yourRheader"
ActiveSheet.PageSetup.CenterFooter = "yourCfooter"
etc...

Regards,
Stefi

€žGer€� ezt Ã*rta:

Hi

Can anyone tell me how to create a header and a footer in excel from a
vb project. I can create the workbook and add text etc to the sheets
but i dont know how to create a header & footer.

Please help

Thanks

You can always record a macro in Excel for the actions you are unsure of.
Not the most efficient code, but it will give you the necessary objects,
methods, properties etc.

Conversion to VB5/6 acceptable code should be pretty straight forward.

NickHK

"Ger" wrote in message
oups.com...
Hi

Can anyone tell me how to create a header and a footer in excel from a
vb project. I can create the workbook and add text etc to the sheets
but i dont know how to create a header & footer.

Please help

Thanks