Consolidate Multiple Excel files with VBA

[TausifRK]

Hi ,

I want to combine multiple excel files with VBA, can someone provide a unique VBA code that will work in any type of excel.


Regards,
Tausif

 

[vletm]

TausifRK
As You have read from Forum Rules

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

... do search from Chandoo.org
There are many that kind of threads.

 

[Marc L]

can someone provide a unique VBA code that will work in any type of excel.

Is it so difficult to use the Search feature of any forum ? Try it to see the samples …​

​

Consolidate data from different excel files (VBA)

Last week, we learned how to use SQL and query data inside Excel. This week, lets talk about how we can use VBA to consolidate multiple data sheets from different workbooks into one single worksheet.

chandoo.org