How to Combine Multiple Excel Files using VBA 

Let me know, in the comments below, which method you found most useful. Make sure to download the source code from the description below the video.

I like your new Camtasia video style, you can see that you put a lot of effort into it. I also like that your videos are more relaxed again (easier to understand for non-native English speakers). Thanks a lot Paul

Paul always shows me A lot little things with the New and simpliest way which is the Best thing to write codes. Thank you Paul. The next thing I would like you to teach me how to make an application complete with its relational databases connected each other. And offcourse, like always, the simpliest way and the fastest aplications.

I know almost every object you use but the very reason I watch your videos is because I learn a lot on how to create clean and comprehensive code. I appreciate the work you do.

I went from not knowing anything about VBA coding to being able to understand what you are saying in this video the first time through. The W.W.W is amazing and people like you make it easy to learn new and amazing things. I started out just wanting to create a program that would automate some B.I. Reports I used daily and it has turned into a full blown application that does it all! I advise anyone with the desire to learn VBA to learn from folks like Paul. Thanks dude, you’re awesome!

Dude, there is a LOT in this video. Excellent job.

man, u are a hero! Thank you very much for this super useful tutorial. i learn a lot from you

Super useful tutorial Helps to improve and streamline automation of work processes.

This is exactly what I have been searching for :)

Paul, congratulations. Another great video.

You Re one of the best developers in this filed sir. Also kindly share work book along with code for my testing. Unable to download this code in browser

Süper çok güzel bir uygulama. Teşekkür ederim.

Very neat. At the moment, I would say all methods described are useful. Can you clarify one? From WriteData, shAll it gives an error on compilation: "Variable not defined". Would you kind enough to explain? How about the Reference > Microsoft Scripting Runtime. Where is that coming from? Thank you kindly.

Very useful.

Thanks Paul. Just know using sub ReadData can pass back data

why i add watches at 7:50 it says out of context

Hello. New to the channel here. Quick question: if the data is jagged what should we use instead of .CurrentRegion

Hi Paul. It's great video. As every that you create. Thank you. Anyway, why do you use intermediate table to temporarily keep data from source worksheets instead of copying directly from source sheet to destination sheet using e.g. Advanced Filter? Is it faster or is it to make the code ore readable?

Hi Paul, Thank you for this video. I want to make a dictionary, so that it contains huge data, so that when I add new sentences to this dictionary, this data must be stored in one of the databases such as Mysql. My question: Is it possible to use Excel as a front-end in order to display this data from the Mysql database, and when we add new sentences it will be stored in the Mysql database?

Hi! Thanks for the video. What about when only the names of the columns are known?

Hello sir, How can i Split a ( 1 Million of rows) large file into 10 small files using VBA macro without filterring dara please help me to code for this problem

I'm curious how reliable these vba codes over the course of time, do they break A lot with updates? is it smart to combine excel formulas with VBA?

How about the opposite, one master file sending data to hundreds of separate files?

The files in the folder have the same structure, file A has 1 sheet, file B has 2 sheets, file C has 3 sheets. Need to create a file D with only 1 sheet with all data of 6 sheets, use VBA, how to do it?

soft source?

The other question: How can we divide an excel file into several files? We need another video to reverse this process: How can we divide this excel file in this video again into several files?

Hi I'm getting error in WriteData() on newRow declaration that "Variable not defined" Could anyone please help me on this?

I want create a VBA tool for collecting data from different Excel to one like same, but for flexible for all types of data like may be sometimes raw and column are changed

I have been following your steps..yet it does not locate the xlsm file i am looking in a folder..

I think Power Query would be better to use here. Can you please explain why choose VBA over PQ for this task ?

Very useful and precise as always. Paul could you expand this a little bit further say i have a huge range of data set and i want to get the uniquue names and ids per employee and get the total data they have on the table

I am light years away from understanding this level of code. What book do you recommend to start with?

Hi Paul, Thank you for an excellent explanation. Unfortunately, the source code file cannot be downloaded 😞

Thanks very much paul, Actually i am having one query when we are running the macro we can't work another excel work how to over come this issue even macro is running we have to work parallel another work also is there any way to over come this problem? Thanks in advance Paul.

GOOD LUCK

Thanks for this video.