Link to home
Start Free TrialLog in
Avatar of BSmiley
BSmiley

asked on

Excel Function for Retrieving SaveDate?

I'm looking for a way to include the date a workbook was saved into a cell in an Excel spreadsheet.  Using the current date/time isn't sufficient, it needs to be the date the file was saved.

I've looked for excel functions to do this and am coming up empty.  Any help would be appreciated.  I don't mind using VB if necessary, as long as it will be treated as part of a formula and will be recalculated as such, seemlessly.

Thanks in advance.
Bob
ASKER CERTIFIED SOLUTION
Avatar of Brian Mulder
Brian Mulder
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of BSmiley
BSmiley

ASKER

Excellent.  It wasn't what I was asking for, but it goes to show that sometimes the user (in this case me) doesn't know the best approach.  Instead of what I was asking for, you gave me something that works even better.  And I learned a lot within the mystery of how VB and Excel integrate.

Thanks so much for the super-fast response.
Bob
Thank you for the grade ...

yes think this is also the best way to start in looking to VBA.

-you got a simple requirement
-you can think it through
-then you look for the correct parts in code

and voila after three times testing it works :)
Bruintje,

As usual I found what I was looking for and your name was on it.  I have one question to add -

Can this solution be used to display the data in a protected cell?

Thanks in advance!