Macro integration into add-ins

[harinsh]

Hi Team,

I have one macro I want to integrate as add-in file because I can't use this code every time into master file because everyday I download file from my database and need to copy my code into that file and then need to run the macro.

Please suggest me how can I make use my macro in different excel files without copy/paste my code...

Thanks,

 

[Jeffrey20]

Store it in your PERSONAL project, that way it will be available to all your workbooks in your computer...

If you have never made use of it then you need to create it; recorde a macro (anything) and select Store Macro in: Personal...
Now go to VBE and you'll see it there, delete the recorded macro and store there the ones you wish to made available to all your workbooks.