Hi,
I would like to do nearly the same as on excel:
https://www.pcreview.co.uk/forums/v...e-and-replace-vba-module-update-t3993504.html
I have to update my modules on several PC and would like to avoid suppress old module and reload new one manually.
Trying to use same function as in excel (Application.VBE.ActiveVBProject.VBComponents), I get an execution error '438'.
Do you have an idea?
I would like to do nearly the same as on excel:
https://www.pcreview.co.uk/forums/v...e-and-replace-vba-module-update-t3993504.html
I have to update my modules on several PC and would like to avoid suppress old module and reload new one manually.
Trying to use same function as in excel (Application.VBE.ActiveVBProject.VBComponents), I get an execution error '438'.
Do you have an idea?