I am trying to write a macro that will download csv files from an online database automatically.

Each of these files has a common file name with a date stamp and a time stamp in the file name:
"filename_20051117_000236.csv"

I have been able to open a file using a macro with a fixed file name like this:

> Sub Test()
> Workbooks.Open Filename:="ftp://user:pw@IP.IP.IP.IP/dataextracts/folder/filename"
> End Sub

What I would like to do (if possible) is to open several files using a loop, but the last digits (time stamp) are not repeatable, as the files are dumped "around" a specific time.

Is there a way to use a loop to d/l several days worth of data, in other words: increment the datestamp, but use a wildcard or something for the timestamp?

Thanks for the help

Lee