Excel Macros

K

kemetivier

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
 
J

Jim Rech

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