Merge data in many CSV sheets to one excel sheet with VBA?

[mabass1990]

Hello
Could you please help me to solve this issue
I have a lot of CSV sheets extracted from sales system and i like to merge all in one excel sheet

 

[Joe4]

Welcome to the Board!

That is a very general question. If you do a Google Search on "mrexcel merge csv files into one excel file", you will find that this question has been asked here many times.
Take a look at some of them and see if they do what you want. If they don't, post back here with more detail.

 

[mabass1990]

Welcome to the Board!

That is a very general question. If you do a Google Search on "mrexcel merge csv files into one excel file", you will find that this question has been asked here many times.
Take a look at some of them and see if they do what you want. If they don't, post back here with more detail.

Thanks Joe
I will search about it, sorry it's my first time to use VBA

 

[Joe4]

Thanks Joe
I will search about it, sorry it's my first time to use VBA

All the more reason to see if you can just use something that has already been created (no sense in "recreating the wheel" if someone has already done the work and you can recycle their code!).

If you search a bunch, and find that none of them do exactly what you want, that means that there are important details/criteria regarding your specific situation that you need to let us know about so we can program for them.

There is a link here on posting tips that will guide you on how to post good, complete questions that maximize the chance of getting responses that will do exactly what you need. The link can be found here: Guidelines

 

[JEC]

I would prefer Power Query for scenarios like this. Maybe you can even connect to the source directly (your sales system)

 

[alansidman]

To follow up on JEC suggestion which is really easy peasy