Lauching procedure in another VB Project directly from the Personal Macro File.

[corentint]

Hello to the community...

I have a personal macro file. Lots of my ribbon buttons/functions refer to this macro file.

I have several addin files with general and also special purpose procedures. Not to be mixed up with my personal macro file.

Each addin file has its own procedure whereby upon running that procedure it automatically exports all objects, userforms, modules and class modules as text files into a separately identified directory. This I consider as backup.
Problem is, I must go into each addin procedure (i.e. into the VBE) to manually start ther procedure, for each addin file.

Surely I should be able to program a procedure in my Personal Macro File that would be run from a ribbon button and automatically produce the require exportation for all addin files?

But I am not sure if this is possible or where to start first (note that I already have a ribbon button that does this for the Personal Macro File, but the procedure resides into the Personal Macro file so it is easy to do; in my request, a procedure in the Personal Macro file would trigger the export procedures in several other Addin files, all in sequence).

Any ideas or recommandations?

Thank you in advance for any help, suggestions, etc.

 

[corentint]

Hello again,

OK, I may have been in a funk when contemplating my requirements. I turns out my writing this request has triggered my own response and a very simple one it is.

In my Personal Macro file, I simply use application.run "nameofaddinfile.xlam!nameofprocedure" where procedures are the export routines of the vba project for each project. One run per Addin. Et Voilà.

So very sorry if anyone wasted time on this request.

Cheers!