On Tuesday, April 2, 2013 12:40:28 AM UTC-4, GS wrote:
The sheet names and the file names will always be the same, but the

file names won't match the sheet names exactly. So I just want to be

able to say always take this file and import to this "specific"

sheet.



As for skipping, sometimes I only want to import 3 of the files and

other times I want to import 5 of the files. They will be contained

in the same folder of the open workbook. So I was just going to edit

the macro and make two different versions - one for the 3 files and

one for the 5 files. The user would then run the specific macro they

needed to run.



Can the user select the files they want, instead of 2 different macros?



Can you give examples of the filenames?



Where do you want to put the file contents on the target sheets? (ie:

below/above existing data, or replace existing data)



--

Garry



Free usenet access at http://www.eternal-september.org

Classic VB Users Regroup!

comp.lang.basic.visual.misc

microsoft.public.vb.general.discussion

I'd rather just have it pull all the files from the same folder. Those names don't change. They are called "DataToday", "DataTomorrow", "DataYesterday", and "DataMonthly". The sheet names are DataToday_TotalDelivery, DataTomorrow_Expected, etc. On import the data can overwrite the data that exists.

Hope that's the information you're looking for. Thanks again for your help.. Much appreciated.

Conor