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!

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!

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!