I am building a spreadsheet for a client. They just have to push a "Refresh Data" button and the magical Excel fairies do the work and give them the data.

Part of this magic includes an external connection to the data stored at an ftp location. There is a report that generates the data every hour and dumps the new file in the ftp folder, replacing the older version (there is only ever one file).

Since the one file is being replaced every hour, I want to be able to, as part of the magic button press, capture the creation date/time of the file that Excel is grabbing data from and populate it in a cell inside the workbook. I can then use this time stamp to say "data current as of XX:XX am/pm"

I get "Run-time error '5': Invalid procedure call or argument" running the following:
Sub GetFileDateTime()
Dim Refreshed As Date
Refreshed = FileDateTime("ftp://ftp.<site>.com/<folder path>/<file>.html")
End Sub
I also tried using the same string that my external connection uses (with username/password) in place of the path but I receive the same error.