| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
merge multiple worksheets from multiple excel files into oneworksheet
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
merge multiple worksheets from multiple excel files into one worksheet
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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Shamoun Ilyas" wrote in message ... 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
merge multiple worksheets from multiple excel files into oneworksheet
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
merge multiple worksheets from multiple excel files into one worksheet
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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Shamoun Ilyas" wrote in message ... 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
merge multiple worksheets from multiple excel files into oneworksheet
Thanks. It worked. Where can i learn VBA online?
On Nov 20, 2:11*am, "Ron de Bruin" wrote: 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 -- Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm "Shamoun Ilyas" wrote in ... 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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
merge multiple worksheets from multiple excel files into one worksheet
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 "Shamoun Ilyas" wrote in message ... Thanks. It worked. Where can i learn VBA online? On Nov 20, 2:11 am, "Ron de Bruin" wrote: 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 -- Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm "Shamoun Ilyas" wrote in ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I merge multiple xls files into one file? | Excel Discussion (Misc queries) | |||
| opening multiple files into one workbook, but multiple worksheets.... | Excel Discussion (Misc queries) | |||
| Open multiple files into multiple worksheets of the same workbook | Excel Discussion (Misc queries) | |||
| How do I merge multiple xls files into one file? | Excel Discussion (Misc queries) | |||
| How can I merge multiple sheets from different Excel files workbo. | Excel Worksheet Functions | |||
Linear Mode
