Adding Excel header

[Jamez36]

I have a form that creates an excel spreadsheet and saves it to disk.
The problem I'm having is that I need a header for the spreadsheet, I can create the header afterwards manually but I need to create it in the vb code before it saves. Anyone incountered this problem or know how to handle it?

 

[JohnH]

Each worksheet has got a PageSetup property object where you can access headers and footers and other page setups relevant to printing the page. There are LeftHeader, CenterHeader, RightHeader and much more.
http://msdn2.microsoft.com/en-us/library/aa174261(office.11).aspx

 

[Jamez36]

Thanks John

Hey that did the trick, I had seen the PageSetup but didn't know how to use it or if it was the way I was gonna solve this issue. Either way thanks.