Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last Modified Date
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last Modified Date
The code below is for the Before_Save event of the workbook. It will put the
current date and time on the right side of the header for all sheets in the workbook. Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Dim sht As Worksheet For Each sht In Sheets sht.PageSetup.RightHeader = "Last Modified On " & Now Next sht End Sub -- Hope that helps. Vergel Adriano "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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Last Date Modified | Excel Worksheet Functions | |||
Modified Date | Excel Discussion (Misc queries) | |||
Last Modified Date help... | Excel Programming | |||
date modified | Excel Discussion (Misc queries) | |||
modified date | New Users to Excel |