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

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