Controlling project references in code

[Bo Hansson]

I need an example that explains how to add and remove project references in
VBA code.

/BosseH

 

[Jonathan West]

I need an example that explains how to add and remove project references in
VBA code.

/BosseH

Hi Bo,

You can add a reference to a probject using the
VBProject.References.AddFromGuid method. You need the GUID of the ActiveX
control in order to add it to the list.

You can also use the Remove method of the references collection to remove a
reference. Code samples are available in the VBA Help file.

 

[Bo Hansson]

Thanks Jonathan,

However, I must say that I cannot find any good samples in the VBA Help
file.
And furthermore, my prime mission will probably be to recognise any missing
references, and then try to supply the targets of these or completely remove
them.
A couple of years ago I saw some tricky samples of how to do this, but now I
cannot remember where, and - one might hope that methods available today are
better and easier to use.

/BosseH

 

[Tom Winter]

Look at my post in microsoft.public.word.vba.addins under "problem with
reference being replicated"