View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.newusers
DebbieSue DebbieSue is offline
external usenet poster
 
Posts: 13
Default I NEED A MACRO!!!!

I got it!!!!! I wasn't clicking Step into, I was clicking Edit. I knew it was
me. Thanks for all the help!!

"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