Can I use a macro in ANY workbook?

[kjg]

Hi to All,

Is there somewhere/someway of storing a macro so that I can use it when I open any workbook.

I have to export a new report to Excel each week and would like to run the macro on this exported report.

I have the macro (found on this site), can this be (easily) done?


TIA

Keith

[Kenneth Hobson]

Depends on what you are doing. If it is in a Module, you can save it to your Personal workbook. If you don't have one, record a macro and when it asks for the name to store it, be sure to select the personal workbook from the drop list. From then on, it will open when you open Excel.

The other method is to do an AddIn.

Note that some macros use ActiveWorkbook which is assumed for some macros or ThisWorkbook. ThisWorkbook is where the macro is stored so this may cause grief if you don't understand the concept.

[kjg]

Hi Kenneth,

That was an amazingly quick reply.

I have tried your suggestion and it works exactly as you explained, that has saved me so much work each week, thank you very much.


Regards,

Keith