File, Save As and then choose text file at the bottom - it will only let you
save the active sheet.


"Jez" wrote:

Hi,

Please help...

I am trying to save one workbook into 2 separeate excel files.

I want to try and save one worksheet as one file and delete other sheets,
then go back to my original data report and save another worksheet as a text
file.

How is this possible??

Thanks,
Jez