Hi Steffen,

Having tested and modified your earlier post I was just about to reply to explain the problems that were left. And now I've found that you've already spotted them so that's saved me some writing. Thank you.

The code works brilliantly except for one thing. When the xlsx file is created I only want the sheet "Data Sheet" to be saved not the whole workbook.

Regards

Keith