Macros 5-19-09 DP

[DebbieSue]

My macro saves a excel file as a text file. I wanted it to do this in
different excel files, but when I go into a file it wants to save it as the
same name as the one I recorded the Macro from. So how can I get it to save
as the name of the file I have open, not the one that the Macro was recorded
from?

 

[Steve Schapel]

Debbie Sue,

The focus of this newsgroup is macros in Access, the database program. You
will have a better chance of a good answer if you re-post your question to
an Excel newsgroup.

 

[Steve Schapel]

Debbie Sue,

The focus of this newsgroup is macros in Access, the database program. You
will have a better chance of a good answer if you re-post your question to
an Excel newsgroup.