Yes this is possible

I will post a example after work tomorrow if nobody else reply.
Bed time for me now

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


wrote in message ...
A list of excel files with complete path is entered into column A of
the workbook. Is it possible to open those files and paste the visible
rows into new excel workbook. There are more than 50 files to be
opened and pasted. One thing need to be sure while pasting, that when
second file is opened and pasted, numbers are pasted at the last row
of new excel workbook created.

Thanks in advance.