Using macro to save xls as txt without changing originial xls file

[Guest]

I was wondering if anyone could help me step through a macro process from
saving a worksheet into a txt file without having the worksheet (which is
part of a template) be turned into txt.

Thanks!

 

[Frank Kabel]

Hi
as starting point:
http://www.cpearson.com/excel/imptext.htm

 

[Guest]

Frank,

Thanks for the speedy response but I am not Visual Basic literate. Is there
any easier step by step way to do this?

Scott

 

[Frank Kabel]

Hi
AFAIK: no

 

[Tom Ogilvy]

select the sheet (only one sheet can be saved)
Do Edit=>Move or copy sheet
select make a copy and New book
Now the sheet is in a new workbook and active. Do file => SaveAs, select a
name and the appropriate type of text file and save it.

Close the file without saving (it has already been saved).