0

We have several VBA excel and word files that we use as templates in a shared network.

The code needs to have an external library as a reference. Is there any way to save the template with this reference as a default and not having to select it every time we want to run the macros?

Norbert
  • 2,741
  • 8
  • 56
  • 111
Despina Karanta
  • 1
  • What kind of external library? Where is it saved? Have you tried saving it in a shared location in the network? Or have you tried adding it using VBA (the VBE object model, AddReferenceFromFile)? – Cindy Meister Jan 21 '20 at 12:13
  • its an executable file. It is saved in everyone's C: drive. I tried to save it in a shared location, but when I go tools/references/browse / this shared folder the library is not loaded, because it already exists in the list of the libraries(of course not selected and its the one located on my c:drive) . – Despina Karanta Jan 21 '20 at 12:46
  • https://stackoverflow.com/questions/9879825/how-to-add-a-reference-programmatically – Siddharth Rout Jan 21 '20 at 14:15
  • thanks! but from the solutions I still have to manually check the Microsoft Visual Basic for applications extensibility library... – Despina Karanta Jan 22 '20 at 14:44

0 Answers0