Header & Footer from vb6

  • Thread starter Thread starter Ger
  • Start date Start date
G

Ger

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:
 
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
 
Back
Top