Thread: merge multiple worksheets from multiple excel files into oneworksheet
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default 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
Reply With QuoteReply With Quote