Add-ins Disabled, Still Need to Run Macros

[pleeseemailme]

Howdy,
We have some terrible accounting software that can spit out data to an Excel file. I've been writing some macros to interact with this data and turn it into something useful. I've been testing it for the past few months now and yesterday I tried it out on another user's machine. I placed the macros in his personal macro workbook. I was shocked to see that the keyboard command to run the macro didn't fire.

After some quick investigation it appears that when the software launches Excel and exports the data to a new workbook, it somehow disables add-ins from loading. I tested this several ways, including making a separate add-in for the user. Nothing worked. It's always worked on my machine to test the macros, because I always already had Excel running - therefore my personal macro workbook was already loaded and could run the macros.

This is very disappointing after so much work on improving these processes. My question is: Is there some magic trick to use to still run macros even when the PMW and other Excel add-ins are disabled? I can't ask all these users to remember to open Excel before exporting the accounting data. What do you think?

 

[RMS123]

Hi there.

I don't know if this will work for you, but is a suggestion.
What I do at work is have a hidden macros workbook (.xlsm) in a shared location and add the Macros to people's ribbon. Once clicked it opens the hidden macro workbook and runs the macro on the active worksheet.
As this is using a seperate workbook, opposed to an "add-in" it may work...

Regards.

 

[pleeseemailme]

Howdy,
That seems like a very viable solution. May I ask how you added a link to the workbook in your ribbon?

 

[RMS123]

Basically have the hidden workbook open and go to the macros list and simply add them to a group.

This should help explain in more detail:
https://support.office.com/en-us/ar...a-button-728c83ec-61d0-40bd-b6ba-927f84eb5d2c

Regards.

 

[pleeseemailme]

That worked like a champ! Thank you for not letting the past months of work go to waste!!

 

[RMS123]

Glad it worked for you!