This script does exactly what I need however I'd like to make it even easier for the user I have in mind.

Ideally I'd make it a macro within the template file I want to give them. Then by them running the macro it would save the CSV's in the same subfolder.

If the source file with the sheets was called "folder\template.xlsm" then running the macro would put the sheets into their separate csv's like this

folder\template.sheet1.csv
folder\template.sheet2.csv
etc.

I'm confident this can be done...I'm just not up to the job!

Thanks - Rob.