That did it - thanks Tom - Although it's a bit ugly to have a new
sheet pop up just to do this ?

Don Guillett's proposed solution leaves the workbook renamed as
aa1.csv, just as my attempt did, so is not a solution.

Thanks,

Richard