Hi,

I guess I need to do both? I need every sheet saved as its own file in that naming order from 001CN00 to 001CN1700.
if i could keep the original worksheet as is that would be great if i couldn't then its not a big deal.

Also at the moment i am using an xls. but when i save the sheets to individual files is it possible to save them as CSV files with the naming as 001CN00 ect? or do i have to manually do it?

Thanks