View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David McRitchie
 
Posts: n/a
Default Automatic Saved Date

Hi Tommy,
Well it really would not be that meaningful, as Excel saves the file practically
all the time. You would have to use a macro.
http://www.mvps.org/dmcritchie/excel/pathname.htm

ActiveSheet.PageSetup.RightHeader = "Saved date " _
& FileDateTime(ActiveWorkbook.FullName)---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"tommy20" wrote in message
...

This sounds awfully basic, but for the life of me, I can't figure out
how to do it.

I would like the date at the top of my spreadsheet to reflect the last
save date for the file. Isn't there a function that will handle this?


--
tommy20
------------------------------------------------------------------------
tommy20's Profile: http://www.excelforum.com/member.php...fo&userid=2817
View this thread: http://www.excelforum.com/showthread...hreadid=528194