merge multiple worksheets from multiple excel files into oneworksheet

[Shamoun Ilyas]

i have around 8000 excel files with more than 30 worksheets in each
file. I want to merge all the information into one "master" worksheet.
can someone please help?

 

[Ron de Bruin]

Hi Shamoun

Try my Merge Add-in
http://www.rondebruin.nl/merge.htm

Or use the code from this page
http://www.rondebruin.nl/fso.htm

 

[Shamoun Ilyas]

Hello Ron,

Your Add-In i have tried. But it does not work because the format of
all the files is actually XML.

The code from your above website are not working as well. it says "Sub
or Function not defined".

Thanks for your help

 

[Ron de Bruin]

Read the info on the site good
I only explain the sub that you must change on the webpage

Download the workbook with code and change the code for the xml extension

 

[Shamoun Ilyas]

Thanks. It worked. Where can i learn VBA online?

Read the info on the site good
I only explain the sub that you must change on the webpage

Download the workbook with code and change the code for the xml extension

 

[Ron de Bruin]

Thanks. It worked. Where can i learn VBA online?

Read the newsgroups

Buy a good VBA book
See
http://www.contextures.com/xlbooks.html


--

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


Thanks. It worked. Where can i learn VBA online?