| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| changing folder order in File Save | Excel Discussion (Misc queries) | |||
| Changing a comma separated text file and save it. | Excel Discussion (Misc queries) | |||
| Using Macro to Save xls to txt without changing file format | Excel Programming | |||
| Changing a macro to save as Unicode text | Excel Programming | |||
| Changing the File Save Properties | Excel Programming | |||
Linear Mode
