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

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


John wrote:
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


--
R-e-t-u-r-n A-d-d-r-e-s-s I-n-s-t-r-u-c-t-i-o-n-s
Change LID to