FileDateTime help

[Ray]

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 D537 and F5:F37 (the filename changes
slightly, I can do this)

Any ideas how to do this.....?

TIA,
Ray

 

[NickHK]

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