Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I save cell data as text?
Hello,
I want to take data in cells in a specific column order (or at least maintain the current order) and save the data in a text file (NOT .csv, it is actually a .gwl file, which is a specifid type of text file for a specific type of application that I need to use). I need to have the text file data in the same order (from left to right) as the data was in the spreadsheet. The data in the text file needs to be separated by semicolons. Is there a macro command for this? The data in the columns will change because it is dependant on imorting data from a separate sheet (this already works just fine). Also, the text file will be reused with different contents, but will need to keep its name the same (i.e. a save command). I think I can suppress the "Do you really want to save this file" command. Sorry for the long-winded post! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I save cell data as text?
See Chip Pearson's site for info and code.
http://www.cpearson.com/excel/imptext.aspx Earl Kiosterud's free TEXTWRITE add-in will do what you want also. http://www.smokeylake.com/excel/text_write_program.htm Gord Dibben MS Excel MVP On Tue, 2 Oct 2007 10:41:01 -0700, nknoepfle wrote: Hello, I want to take data in cells in a specific column order (or at least maintain the current order) and save the data in a text file (NOT .csv, it is actually a .gwl file, which is a specifid type of text file for a specific type of application that I need to use). I need to have the text file data in the same order (from left to right) as the data was in the spreadsheet. The data in the text file needs to be separated by semicolons. Is there a macro command for this? The data in the columns will change because it is dependant on imorting data from a separate sheet (this already works just fine). Also, the text file will be reused with different contents, but will need to keep its name the same (i.e. a save command). I think I can suppress the "Do you really want to save this file" command. Sorry for the long-winded post! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I save cell data as text?
Fantastic!
Thanks "Gord Dibben" wrote: See Chip Pearson's site for info and code. http://www.cpearson.com/excel/imptext.aspx Earl Kiosterud's free TEXTWRITE add-in will do what you want also. http://www.smokeylake.com/excel/text_write_program.htm Gord Dibben MS Excel MVP On Tue, 2 Oct 2007 10:41:01 -0700, nknoepfle wrote: Hello, I want to take data in cells in a specific column order (or at least maintain the current order) and save the data in a text file (NOT .csv, it is actually a .gwl file, which is a specifid type of text file for a specific type of application that I need to use). I need to have the text file data in the same order (from left to right) as the data was in the spreadsheet. The data in the text file needs to be separated by semicolons. Is there a macro command for this? The data in the columns will change because it is dependant on imorting data from a separate sheet (this already works just fine). Also, the text file will be reused with different contents, but will need to keep its name the same (i.e. a save command). I think I can suppress the "Do you really want to save this file" command. Sorry for the long-winded post! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SAVE & SEND A FILE BASED ON TEXT IN A CELL VIA MACRO | New Users to Excel | |||
how to save Excel data as ASCII* text? | Excel Discussion (Misc queries) | |||
enter data in cell but cannot save until click off cell in excel | Excel Discussion (Misc queries) | |||
Save file as text from cell | Excel Discussion (Misc queries) | |||
How can I make Excel Files save as the text appers in a cell, can. | Excel Discussion (Misc queries) |