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

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!

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

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

--
Regards
Frank Kabel
Frankfurt, Germany


ssciarrino wrote:
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!

Using macro to save xls as txt without changing originial xls
 

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

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

--
Regards
Frank Kabel
Frankfurt, Germany


ssciarrino wrote:
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!

Using macro to save xls as txt without changing originial xls
 

Hi
AFAIK: no

--
Regards
Frank Kabel
Frankfurt, Germany


ssciarrino wrote:
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" wrote:

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

--
Regards
Frank Kabel
Frankfurt, Germany


ssciarrino wrote:
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!

Using macro to save xls as txt without changing originial xls
 

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).

--
Regards,
Tom Ogilvy


"ssciarrino" wrote in message
...
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" wrote:

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

--
Regards
Frank Kabel
Frankfurt, Germany


ssciarrino wrote:
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!