software

Is there any way to save an excel spreadsheet as a text file within a
macro?
I am using a macro to import data from a text file. I then need to save
that sheet as a text file to place it in a software interface.

Most appreciated,
Kylegt;gt;I then need to save that sheet as a text file

As with many things a good place to start is recording a macro as you do
this manually (using File, Save As and selecting the text file format).

--
Jim
gt; wrote in message oups.com...
| Is there any way to save an excel spreadsheet as a text file within a
| macro?
| I am using a macro to import data from a text file. I then need to save
| that sheet as a text file to place it in a software interface.
|
| Most appreciated,
| Kyle
|