Macros To Save Worksheet as New xlsx file & Save Another Worksheet As A Text File

Steffen,

Sincere appologies if you feel I've mislead you, that certainly wasn't the intention.

I'd tried to make myself as clear as possible and I hoped that "save the sheet “Data Sheet” as a new xlsx file with values and formatting" would be enough but I can see now that I should have been more specific. As you know it was an Example workbook that I posted as I couldn't post the actual one that I'm working on. Unfortunately I forgot to format the Data Sheet the same as the original in respect to the sheet middle header and print setup which didn't help.

I've tried the new code and it works, but still loses the sheet header and print settings. I've posted a new file ExampleData_05.xlsm which has the correct formatting for the Data Sheet and includes your code.

Regards

Keith