Import multiple CVSs to one worksheet - Modify VBA code

Hello guys!

I do have great script, but it's working not exactly as I need. It's allow to set strarting location (required), select location of CSVs (required), allow multiple selection (required) and finally insert imported data in separate worksheets (this one works not as needed). I want to insert data on one active worksheet. I no need new worksheets/tabs for each file.

I've tried to modify script, but no luck. I've turned off creation of new worksheets, changed destination to active sheet, but stumbled on merging data into one worksheet. This script is not oriented on this by design and require more serious mods.

Here is original (not modified) code:

Please Login or Register  to view this content.

Please help to modify it.

I am not a programmer and may spend days on solving this issue.

Beforehand thanks!

hi EIKA, welcome to Excelforum, try this out, the changes have been made to ImportCSV only

Please Login or Register  to view this content.