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
/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
--
tekman
------------------------------------------------------------------------
tekman's Profile:
http://www.excelforum.com/member.php...o&userid=28843
View this thread:
http://www.excelforum.com/showthread...hreadid=486139