Save As Macro?

J

jsmonje

I use excel 2002 to convert tab delimited text files to .xls. I woul
like a macro to save these file in .xls format.

I open a read only file = filename.txt, make some changes, and need t
save it (save as) in the same directory as filename.xls.

Any help would be appreciated
 
J

Jim Rech

You might start by recording a macro as you perform the actions manually.

--
Jim Rech
Excel MVP
|I use excel 2002 to convert tab delimited text files to .xls. I would
| like a macro to save these file in .xls format.
|
| I open a read only file = filename.txt, make some changes, and need to
| save it (save as) in the same directory as filename.xls.
|
| Any help would be appreciated.
|
|
| ---
|
|
 
Top