Great, but it does not work. It only imports three or four of them. It
cycles through all of the files, but only about 70 lines of the first
four files come over. The rest of the files are shown in the log, but
without the "yes" beside them.

If the files are 2007 Excel format, and I am trying to import them using
2003, would that explain it? Unfortunately, the creator of these files
left on a two week trip to China, so it may take a bit to determine if
he is indeed using the later version...

Thanx






Ron de Bruin wrote:
Hi Phil
Try this add-in or try the code on the other pages
http://www.rondebruin.nl/merge.htm