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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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 :)
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!
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!
ASKER
Thanks so much for the super-fast response.
Bob