View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Trevor[_4_] Trevor[_4_] is offline
external usenet poster
 
Posts: 9
Default Applying Macro to all workbooks...

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.