2003 save workseet as

[John]

In Office 2003 excel

I'm trying to decipher how to save a worksheet which is explained in the
help files. Coming up short.

Say I want to save worksheet(n). Could someone write an example? Like to
save it as msdos txt or word? there seems to be about 25 choices but I
still don't understand the form.

Thanks

 

[John]

From recording a macro I got this: ("Record 7" is the name of the
worksheet I wanted to save and "billing thingy.txt" is the name of the
file I save it to)

Sheets("Record 7").Select
Range("A1:E39").Select
ChDir "C:\Temp"
ActiveWorkbook.SaveAs Filename:= _
"C:\Tempp\billing thingy.txt" _
, FileFormat:=xlText, CreateBackup:=False

This seems to work except:

When the macro is finished the worksheet is renamed to the file name I
used. I don’t know why or how that happens and I suppose I could just
rename the sheet back again. But is there a way to make that NOT happen?

Thanks

John