Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Daniel,
Dim dateLastSave As Date dateLastSave = FileDateTime(ThisWorkbook.Name) MsgBox dateLastSave Note: ThisWorkbook.Name can be replaced with the name of the workbook in double quotes and it can be any other workbook as well as the current one. However, will need to include the path if it is not in the current default path. Example (In current default path): dateLastSave = FileDateTime("My Other workbook.xls") -- Regards, OssieMac "Daniel Jones" wrote: Does anyone know how to access the properties for the last date/time an .xls file was saved within VBA? Thanks. D . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Properties Tab on Doc Save | Excel Discussion (Misc queries) | |||
Save with preset Printer Properties | Excel Discussion (Misc queries) | |||
Save As Dialog does not prompt for Web File Properties | Excel Programming | |||
Properties transferring from excel cells to word file properties | Excel Programming | |||
Changing the File Save Properties | Excel Programming |