I tried the first two suggestions and it still didn't work. I'm sure I'm
doing something wrong, but I don't know what it is. I'm running excel 2003. I
don 't know if that makes a difference.
Details: After I open my file I go to Record Macro, name it and then I have
to delete a line in my spreadsheet. After that I just go to Save As and click
Text and save it to "This workbook". I have to save it to a file on my
desktop. End of story. I looked for it and it's not there. I did go back into
the file and did a Save As but I wasn't really sure where I should be saving
it to. I don't have a Type called Normal Workbook, just MS Excel Worksheet.
If that makes a difference.

"Dave Peterson" wrote:

And you're re-opening up the .xls* file--not the text file, right???

If you're using xl2007, make sure you save the workbook as a macro enabled
workbook (*.xlsm).

If you're not using xl2007, you may want to share the exact details of what
you're doing.



DebbieSue wrote:

I tried what you said and it still didn't save it.

"Dave Peterson" wrote:

If you save the file as a normal workbook, then the recorded macro will be saved
with that workbook.

So record your macro when you save it as a text file. Stop recording. Save the
file once more as a normal workbook.



DebbieSue wrote:

I have an excel file that I always save as a text file for importing into
another program. I was wondering if a Macro could be made to do this? I have
tried to record the Macro as I do it, but it didn't even save it.

--

Dave Peterson


--

Dave Peterson