Where do I save a macro that makes changes to many files?

[az!]

Hi,

Could you please tell me where I should save a macro that makes changes to many files? Could I have one main macro that is an executable file? For instance, I save the macro in my reports folder and when I double-click on it, the macro runs (opening, changing and closing different Excel files).

Thank you in advance for your help!

[Domski]

You could store the code within your Personal Macro Workbook (if you don't have one it's easy to create).

Alternatively you could create the macro and store it within a regular module within a normal Excel workbook and convert it to an add-in.

Dom

[az!]

Hi Dom,

Would you let me know how to store the code within my Personal Macro Workbook?

Thank you!

[Domski]

Have a look here: http://www.rondebruin.nl/personal.htm

Dom

[az!]

Hi Dom,

Thank you very much for your help!