View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
nknoepfle nknoepfle is offline
external usenet poster
 
Posts: 2
Default 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!