software

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: www.excelforum.com/member.php...foamp;userid=2817
View this thread: www.excelforum.com/showthread...hreadid=528194Hi 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.
www.mvps.org/dmcritchie/excel/pathname.htm

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

quot;tommy20quot; gt; wrote in message
...
gt;
gt; This sounds awfully basic, but for the life of me, I can't figure out
gt; how to do it.
gt;
gt; I would like the date at the top of my spreadsheet to reflect the last
gt; save date for the file. Isn't there a function that will handle this?
gt;
gt;
gt; --
gt; tommy20
gt; ------------------------------------------------------------------------
gt; tommy20's Profile: www.excelforum.com/member.php...foamp;userid=2817
gt; View this thread: www.excelforum.com/showthread...hreadid=528194
gt;

David McRitchie Wrote:
gt; Well it really would not be that meaningful, as Excel saves the file
gt; practically all the time. You would have to use a macro.
gt;

The spreadsheet I need it for is only updated every couple of weeks,
and I manually change the release date. I was hoping that Excel could
do it for me, as I often forget.

I guess it's time to re-learn macro's, as I haven't used one in years.

Thanks!--
tommy20
------------------------------------------------------------------------
tommy20's Profile: www.excelforum.com/member.php...foamp;userid=2817
View this thread: www.excelforum.com/showthread...hreadid=528194