Import Macro to import separate files to separate worksheets - deletes existing worksheets

I have a script that imports mulitple .csv files into seperate worksheets - works great... However, when it imports all the files, it deletes any existing pages - ie a summary sheet..... Is there any eay way to set it so it doesn't removed any existing worksheets after the import


THis is the script

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

You are putting the sheets into the first of the CSV files, so that sheet does not exist. You can control which workbook you are putting all the sheet into - this uses the activeworkbook:

Please Login or Register  to view this content.