I'd rather just have it pull all the files from the same folder.

You said the number of files each time will vary (3 or 5). Does this
mean that at any given time the folder will only contain the correct
number of files for processing? If so, this suggests you'll also need
to delete or rename or move the existing files. What's your preference?
In the case of rename/move specify the criteria details.

This folder can be set as the default for the browser. The user will
only see CSV files if that's what you want. Please confirm...

Those names don't change. They are called "DataToday",
"DataTomorrow", "DataYesterday", and "DataMonthly". The sheet names
are DataToday_TotalDelivery, DataTomorrow_Expected, etc.

So the filenames are...

DataToday.CSV
DataTomorrow.CSV
DataYesterday.CSV
DataMonthly.CSV

...and their target sheetnames contain *exactly* the same text left of
the ".CSV" part.

On import the data can overwrite the data that exists.

Easily done!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion