Code for Current Date in the Header

[dh31]

I am looking for code that will add the current date (MM/DD/YY format)in the header section.

 

[firefytr]

Hi there,

Not sure what application you're even talking about, but if it's Excel ...

Sheets("Sheet1").Pagesetup.centerheader = format(date, "mm/dd/yy")

HTH

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci

 

[fumei]

And if it is Word, AND it is for the Primary header of Section 1....

 ActiveDocument.Sections(1).Headers(wdHeaderFooterPrimary).Range _
   .InsertDateTime DateTimeFormat:="MM/dd/yy", _
    InsertAsField:=False

Of course if it is for a different header, then wdHeaderFooterPrimary would have to be changed. If it is for a different section, then Sections(1) would have to be changed.

Gerry
My paintings and sculpture