Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I think you have two choices, but delete your latest change in both cases:
Choice 1: First, delete the "ChDir PathName" line. Second, try using this line: LastModDate = FileDateTime(PathName & FName) Choice 2: Insert a line before this: ChDir PathName to: chdrive pathname ChDir PathName and you should be able to use: LastModDate = FileDateTime(FName) === I'd use choice 1. The chdir won't work if you ever decide to use a UNC path (\\someserver\somefolder\) instead of the mapped drive. HelenA wrote: An update : I've added a line just into the start of the loop: FName = PathName & FName But now, it's just reporting on the same file over and over - it's not looping through the file. Once again, any suggestions would be helpful. Thanks to Chip for the steer in the right direction to start with! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
File Creation Date | Excel Worksheet Functions | |||
How can I get date of file creation to XLS cell in date format? | Excel Worksheet Functions | |||
File Creation Date | Excel Discussion (Misc queries) | |||
How to get the creation date of imported file? | Excel Programming | |||
file creation date | Excel Worksheet Functions |