View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jim Jackson Jim Jackson is offline
external usenet poster
 
Posts: 324
Default Last Modified Date

Sub TEST()
s = "H:\Projects\Projects.xls"
dt = FileDateTime(s)
With ActiveSheet.PageSetup
.CenterHeader = dt
End With

End Sub
--
Best wishes,

Jim


"Me" wrote:

Can I put the last modified time and date into a header in Excel 2003?

If so, how would I do that?

Thank you in advance.