Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi, I'm in a bit of a quandry and I hope the group can assist. We have
Excel workbooks that are sent to one individual to save in a measurement repository. I'm extracting data from these files and have been using the date extracted from here Set RootFolder = Fso_Obj.GetFolder(myPath) For each File in RootFolder.Files myModifyDate = File.datelastmodified Next File The problem I *think* I'm running into is that thie date is the date that the original user last modified the file, not the date the file is saved to the repository. Is there another date I can get from the File Object that shows the date saved to the repository. THe file is not edited, it's just downloaded from an email. Thanks in advance, Barb Reinhardt |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date open file with date saved | Excel Worksheet Functions | |||
How can I capture the last date a file was saved in the footer | Excel Discussion (Misc queries) | |||
Date modified changes when file not saved | Excel Discussion (Misc queries) | |||
how do I show last date file saved? | Excel Worksheet Functions | |||
Open file saved as today's date | Excel Programming |