The best way to add macro automatically to an excel doc

[jbesclapez]

Dear MrExcel,

I hope you are fine. I am fine too. I am getting better and better with macros now... and thanks to your help because you are always there

I have a question which is not directly linked to macros but inderectly.

I have an excel file XLS that i download from a server. I created a macro for it. It is running smoothly...

However, each time i have to add a module and paste my code to make the macro run...

Is there a better or an alternative to that? something easier? Have you got any advice?
I was thinking of creating another worksheet that would be a kind of starting point where i could "inject" the other worksheet that needs to be run macro on. I hope i am clear... (english is not my native language).

Thanks to be here!

 

[VoG]

Try putting the code in your Personal workbook http://www.rondebruin.nl/personal.htm

 

[jbesclapez]

Did that... thanks a lot, that is a solution i heard about but i am going to use for real now .
Thanks