Best way to update macro's?

[Troy1]

Hello Guys,

I am trying to figure out the best way to update macros on my coworkers macros. They all have workbooks saved on there computer tailored to there specific terminals they cover. However they all use the same macro's (email macros, formatting macros, etc) embedded into each of there workbooks. Every time I want to update there macros I have to do it about 50 times for each workbook.

I am wondering if there is a way to have peoples macro's to automatically update when I update a master macro file or have the ability to create a new macro that will automatically install on everyone's workbook.

I have done research on this online and people are saying to create an add-in then somehow work it into a template. But I do not understand how this will automatically update there macros or add new macros to there workbooks. They can not create a new workbook everyday they have to use the workbooks they already have because all of there data is in there with tons of formulas, charts, etc.

Can someone please help me out?

 

[Troy1]

Hello SHG,

How would I create a "standard code module" in the add-in? I already have the add-in created so I do go into it and install the 123 macro so it will work when I press the button?

 

[shg]

In the VBE, select the project, Insert > Module.

 

[Troy1]

In the VBE, select the project, Insert > Module.

Yeah that's what I did and when I open the add-in it does show the macro created under my add-in project. Not sure what is going on! Everything seems that it should work but it still gives me the error that it can not find the macro.

Any other suggestions?

 

[shg]

Dunno. Put the workbook on box.net and post a link.

 

[Troy1]

Dunno. Put the workbook on box.net and post a link.

Here is a copy of my add-in and excel spreadsheet I am trying to install it in.


Add-in:

 https://drive.google.com/file/d/0B7ZAZgflZvezZHUyZnVPUzlGYmM/edit?usp=sharing

Spreadsheet:

 https://drive.google.com/file/d/0B7ZAZgflZvezRHBYeDZSQmhrd0U/edit?usp=sharing

 

[shg]

Change the name of the module to something other than "123", or change the code from "123" to "123.123"

 

[Troy1]

Change the name of the module to something other than "123", or change the code from "123" to "123.123"

Hahaha that worked great! I can't believe it was that simple. Thank you so much for all of your help!

 

[shg]

You're welcome.