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
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
|