Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

Solved: Show last edit date in Excel ?


(!)

New2XP's Avatar
New2XP New2XP is offline
Computer Specs
Member with 37 posts.
THREAD STARTER
 
Join Date: Sep 2005
Location: Richardson Texas
Experience: Intermediate
17-Dec-2006, 03:44 PM #1
Question Solved: Show last edit date in Excel ?
In EXCEL (Office 2002) Is there a way to have a header that is auto matically updated to show the date the file was last edited(changed) ? . It should do this each time the file is edited(changed). Then when the file (.XLS) is emailed to someone and they print it, The last "edit(changed)" date will show .Currently the local date the file is printed is showing.
Manually editing the header is forgotten at busy times.
Zack Barresse's Avatar
Computer Specs
Member with 5,434 posts.
 
Join Date: Jul 2004
Location: Oregon, United States
Experience: I'ma learnin'!
17-Dec-2006, 04:43 PM #2
Hi there,

Please define in detail what exactly you mean by last edited date? Do you mean the document properties? After specific changes? Is this for one file?
bomb #21's Avatar
Member with 8,268 posts.
 
Join Date: Jul 2005
Location: The void AKA edge of the Fens
Experience: I bent my wookie :(
17-Dec-2006, 05:16 PM #3
You probably really want the date/time of last save, as unsaved edits would be immaterial. (?)

Try this code in the workbook module (which you can access by rightclicking the Excel icon to the left of "File" in the menu bar):

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
ActiveSheet.PageSetup.LeftHeader = "Last edit: " & Date & " " & Time
End Sub
New2XP's Avatar
New2XP New2XP is offline
Computer Specs
Member with 37 posts.
THREAD STARTER
 
Join Date: Sep 2005
Location: Richardson Texas
Experience: Intermediate
17-Dec-2006, 08:41 PM #4
B#21
That is axactly what I was looking for. Will give it a try and
post the results.
Thanks
OBP's Avatar
OBP OBP is offline OBP is a Trusted Advisor with special permissions.
Computer Specs
Trusted Advisor with 18,545 posts.
 
Join Date: Mar 2005
Location: UK
18-Dec-2006, 06:19 AM #5
New2Xp, there was a previous thread either on here or on VBAX where every cell changed had it's change logged in the Cell's Comment, which you might want to look at for another way of recording changes.
Zack Barresse's Avatar
Computer Specs
Member with 5,434 posts.
 
Join Date: Jul 2004
Location: Oregon, United States
Experience: I'ma learnin'!
18-Dec-2006, 12:56 PM #6
New2XP, fyi, Andy's code will put the current System date and time (as the time when the code is executed) into the header, which will not be the "Last edited date" such as in the document properties.
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑