What are the file extensions? If they are .xls they ought to be Excel 2003
or earlier, but if they are .xlsx (or a number of other varieties) they are
probably 2007.
--
David Biddulph

"Phil Smith" wrote in message
...
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