I don't understand. A CSV will not contain "several sheets", it can only contain 1 sheet and that is how it is imported. If the file must be parsed into different worksheets, you will have to be very specific about how to do that...

Thanks for getting back to me. I will try this. Another method that I may adopt is to open existing files and to copy the data from each of the sheet into the appropriate workbook instead of exporting and saving each of the sheets