Optionally opening a large VBA project

[Ed]

I bought a commercial Word addin a while back that is quite large, and takes
a (relatively) long time to load. It slows down Word's loading by about 10
(interminable) seconds! (I know it is not really a long time, but it feels
like it.)

Sometimes I never use the add-in. I really only want it to load when I
tell it to. Is there any way that I can write a macro that will optionally
load or not load the add-in. Do I need to move the add-in to another (not
the startup) folder? But if I put it there, how do I call it up. I hope this
is clear.

Ed

 

[Howard Kaikow]

Is the add-in a Word template?
If so, all templates in the Startup directory are automatically loaded when
Word starts.

You could put the template elsewhere and then manually load/unload the
template, as needed, using the Tools | Templates and Add-ins menu, or you
could write a macro to load/unload the template.

 

[Chuck]

This will open a valid template on any drive/folder that you specify:

'if template exists
If Dir$("c:\path\template.dot") <> "" Then
'load add in
AddIns.Add _
FileName:="c:\path\template.dot", _
Install:=True
End If

 

[Chuck]

Sorry I meant to say that the code I posted will *add-in* any template you
specify, not "open".