SOLVED
Import multiple CSV excel files with different sheet name
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
mihaicom20
8 - Asteroid
‎12-29-2021
04:53 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello everyone,
I am trying to merge multiple excel files that have CSV extension and the sheet name is different for every file. The files schema is the same.
Is there any macro that can merge multiple CSV excel files? I tried to find smth similar on community.
Thank you in advance!
Solved! Go to Solution.
4 REPLIES 4
binuacs
21 - Polaris
‎12-29-2021
05:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎12-29-2021
06:00 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@binuacs I tried this kind of macro, but the problem is that I don't know how to apply it to CSV files
‎12-29-2021
06:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@binuacs I found this as a solution
binuacs
21 - Polaris
‎12-29-2021
06:46 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@mihaicom20 thanks I made some changes in the batch macro which i initially to only read .csv files with different sheet name
