Save As Macro?

  • Thread starter Thread starter jsmonje
  • Start date Start date
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
 
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.
|
|
| ---
| Message posted
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro For Saving As .txt 1
Saving as .xlsx from VBA MACRO 4
save as macro 1
Relative path in database query connection string 1
CSV Tab Delimited 4
Macro for Save As 2
Creating macro to use on different workbooks 1
Macro to save as 2

Back
Top