Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last saved
HI,
How can i put the information about last save into the cell? code or a formula does not matter. Thank you Igor |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last saved
For Excel 2000 and higher you can use this
Range("a1").Value = ThisWorkbook.BuiltinDocumentProperties("Last Save Time") Note : This is not working correct in Excel 97 Read this from Tom Ogilvy Note that this property is not maintained in xl97. However, if the workbook is created/used in both xl97 and later versions, then when used in the later versions and saved the property is maintained but when used in xl97 and saved, the property is not altered. The time it was last saved in the later version will be retrieved if this property is called. If created and used exclusively in xl97, calling this property will raise an error. You can use the beforesave event to update this property in xl97 as a workaround. Just test the version of excel and if xl97, update the property. You can use this then Best to use the before save event under the Thisworkbook module Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, _ Cancel As Boolean) Range("a1").Value = Date End Sub right click on the Excel icon next to File in the menubar Choose view code Paste this event there Alt-q to go back to Excel If you save the file the date will be placed in A1 -- Regards Ron de Bruin (Win XP Pro SP-1 XL2000-2003) www.rondebruin.nl "igor" wrote in message ... HI, How can i put the information about last save into the cell? code or a formula does not matter. Thank you Igor |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last saved
What kind of last save information are you looking for:
perhaps "Last Save Time". Be aware that Excel has lots of volatile functions like the date and time that will cause Excel to ask you to save the file, so it actually becomes more a matter of when you last used the file than when you actually had changes. Properties http://www.mvps.org/dmcritchie/excel/property.htm -- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "igor" wrote in message ... HI, How can i put the information about last save into the cell? code or a formula does not matter. Thank you Igor |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last saved
actually code above helped partially, but i still would like to have a Excel usermame saved next to the date and time. Thank you for your help *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Last saved
Did you know what you wanted when you first asked the question,
if so the more explicitly you ask the question the closer the answer will be to what you want. Otherwise you build up by bits and pieces like everyone else including those of us in the Excel newsgroups <grin. Try this User controlled Save History as an alternative to Highlight Changes (#BeforeSave) http://www.mvps.org/dmcritchie/excel...htm#beforesave More information on Event macros in http://www.mvps.org/dmcritchie/excel/event.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "excel programming" <http://communities.microsoft.com/newsgroups/default.asp?icp=prod_office&slcid=US wrote in message ... actually code above helped partially, but i still would like to have a Excel usermame saved next to the date and time. Thank you for your help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I recover an Excel document saved not saved as | Excel Discussion (Misc queries) | |||
i "saved" instead of "saved as". I need old file back | Excel Discussion (Misc queries) | |||
Files saved as csv files are actually saved as text files? | Excel Discussion (Misc queries) | |||
How can I see a copy of a saved workbook before I saved it again? | Excel Worksheet Functions | |||
How to get saved old saved work that was saved over? | Excel Discussion (Misc queries) |