FileDateTime help
Hello -
I need to pull in the update_date from approx 60 files and need some help in building an 'updateable' macro. I'm familiar with the FileDateTime methodology, but only in a static application -- ie, the file names don't change. Let me explain the data format: 1) Store#'s are in cells B5:B37 (these are non-sequential, eg 153/211/215/etc) 2) Filename is like this: \\Server\Drive\Folder\File_[Store#]_[B1].xls -- where Store# comes from B5:B37 and [B1] is the value of cell B1 3) update_dates go in cells D5:D37 and F5:F37 (the filename changes slightly, I can do this) Any ideas how to do this.....? TIA, Ray |
FileDateTime help
Ray,
Assuming you already have some function to get the FileDateTime (maybe called "GetFileDateTime"), you can just call that function with =GetFileDateTime("\\Server\Drive\Folder\File "_& B5 & B$1 & ".xls") NickHK "Ray" wrote in message oups.com... Hello - I need to pull in the update_date from approx 60 files and need some help in building an 'updateable' macro. I'm familiar with the FileDateTime methodology, but only in a static application -- ie, the file names don't change. Let me explain the data format: 1) Store#'s are in cells B5:B37 (these are non-sequential, eg 153/211/215/etc) 2) Filename is like this: \\Server\Drive\Folder\File_[Store#]_[B1].xls -- where Store# comes from B5:B37 and [B1] is the value of cell B1 3) update_dates go in cells D5:D37 and F5:F37 (the filename changes slightly, I can do this) Any ideas how to do this.....? TIA, Ray |
All times are GMT +1. The time now is 10:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com