Importing Multiple CSV Files Into One Worksheet

[GrimeyOne]

Hello, I'm new here. I have a task that I perform daily where I manually paste 5- 10 csv files into one worksheet. I'd like to run a VBA module to pull these csv's from a folder on my desktop and import them all into one worksheet. If someone could share a code to do that, I would be very appreciative.

[sandy666]

Another than VBA way
get PowerQuery add-in for Ex2013 Pro Plus from MS site
then : Data - New Query - From File - From Folder

From Folder is a folder where your CSVs are

[GrimeyOne]

Thanks, sandy!! That worked perfectly. Can't thank you enough.

[sandy666]

You are welcome

If that takes care of your original question, & to say Thanks, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)
then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED.
If you did it already - ignore it.
Thank you.