ExcelBanter - merging multiple files

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - merging multiple files (https://www.excelbanter.com/excel-discussion-misc-queries/79834-merging-multiple-files.html)

ILXCEL

merging multiple files

Is there a way to merge multiple files where the worksheets have the same
name without manually opening every worksheet?

Ron de Bruin

merging multiple files

Hi ILXCEL

See this page for a few examples
http://www.rondebruin.nl/copy3.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl

"ILXCEL" wrote in message ...
Is there a way to merge multiple files where the worksheets have the same
name without manually opening every worksheet?

All times are GMT +1. The time now is 03:04 PM.