Multiple macros for several files that change weekly - where to store macros

Hello,

I hope I describe my need so that someone can help. I don't know VBA very well.
Each week I will get new Excel files. Some files will have a standard naming convention (i.e. ABC mm/dd/yyyy; month/day/year will represent the date data was generated). Some files the name will not have a standard naming convention. Also the worksheet names in the files will also be different; the names change by date generated. The one constant for all the files is the format of the data. While each file contains different data, there will be one key field among the various files that relate.

I know how to create simple macros to perform repetitive tasks, insert column, filter, change a column color, etc. Since I am working with various files that change weekly, I can't create a macro in each of these files for repetitive use. Where would I store (keep) macros I create to use when I open specific files to perform repetitive tasks. Please note that I may have to share the macros with other users when there is a need for someone else to generate the require data.

TIA,

Kind regards,
Jan

Hi Scott,

Thank you for you quick replay and information.

I will have to research the add in feature since I am not familiar with that process.

Kind regards.
Jan

Hello,

Ok, I have created an Add in. I see it listed on the Developer tab under Add-in. What I can't seem to figure out is how to use it with a new workbook that is opened.

Any help will be appreciated.

TIA

Regards,
Jan

Hi Scott,

The is the code

Sub MyNames()

Range("A1").Select
ActiveCell.FormulaR1C1 = "Jane"
Range("A2").Select
ActiveCell.FormulaR1C1 = "Timon"

End Sub

Kind regards,
Jan

if you want your macro code available to your use on other workbook what scottiex suggested use the personal.xlb
go to visual basic editor--->project explorer
right click PERSONAL.XLSB
select insert module
then paste all the code you want in there then save
to use the macros on workbooks press ALT+F8
it will list all the available macros
select which macro you choses then click run