Opening multiple CSV files into the same excel sheet
Is there a way to open multiple CSV files into the same excel sheet? It's only helpful if it is quicker than opening individually and copy/pasting. I need to do this daily.
Ideally, I'd like to highlite the 14 files, right click and have an option right there. Is that possible? I would like to avoid using access and keep it simple...
I have some moderate excel programming experience so any amount of detail/insight would be much appreciated.
Stick with the simple approach.
Use a loop to open each csv and copy/paste to master sheet.
If the csv has fields that need special consideration, such as dates or leading zeros, then use the QueryTables method to import a file and then copy/paste it.
Hi
save the attached file inside the folder which you wish to pull data from and run the macro
Ravi
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks