msgbox displaying time passed since last save
I have the following code:
but i would like to expand the "welcome back" msgbox to also display "the last time you were was was (eg: 2 days/3 hrs/14 min) ago" - which i presume would be calculated from the last save.
Please Login or Register to view this content.
I did ask this question in another forum but after a few hours, i was unsuccessful in getting a solution at this time.
Any assistance or redirection would be greatly appreciated.
A quick search brought me to this site
http://www.cpearson.com/excel/docprop.htm
I don't know if it will help but could be good information
Thanks for your time davesexcel. I will take a look at it and maybe it will work for me.
Thanks again.
That helped a bit davesexcel.
However i had to still figure lots out. Using ActiveWorkbook.BuiltinDocumentProperties.Item(12) - setting it into a worksheet and using date functions in excel, separating the info, comparing it to NOW() and then drawing them back to workbook_activate and concatenating everything in a msgbox.
Now it does EXACTLY what i wanted it to do!
Last edited by Jedody; 03-08-2007 at 01:12 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks