Import and consolidate multiple files

[D Zandveld]

Hi All

I have several (maybe 10 or so) Excel or .csv files (all in the same
format), each with only one worksheet of data.
Generally they will be in one directory, but i'd like to give the user the
choice at this stage (I can fix this later).

I would like to import the selected files (using a Dialogue Box &
multiselect) into a single specific worksheet (named "Vendor Import") in
"MASTER.XLS" one under the other.

Then, search for any duplicate records (the header field) and strip them
out. I assume this can be simplified by doing it before the merge.

I have done something like this before, but I lost the code and am rusty, so
appreciate your help.

 

[D Zandveld]

I should mention, MASTER.xls already exists.

 

[Ron de Bruin]

Hi D Zandveld

For csv files see
http://www.rondebruin.nl/csv.htm

Try this example for Excel files
http://www.rondebruin.nl/copy3.htm