hard to say without seeing the macro, but in general, if you use
activcecell, activesheet, activeworkbook rather than specific names for
these, it should work with the current workbook/sheet/cell.

--
Regards,
Tom Ogilvy


"Trevor" wrote in message
...
Hello All,

I have created a macro that I need to use whenever I
import a text file. However, the macro is only associated
with the file that I wrote it in. How do I make it
available to any file I have open? As of now, I have to
go find the original file I wrote the macro for and
copy/paste the code into the current workbook. I know
there has to be a better way. Any help is much
appreciated.

Thanks.