Check and Set References with VBA

**wotadude** · 03-11-2009, 04:35 PM

for example, is it possible to check if a Reference to Set a reference to Microsoft Internet Controls (shdocvw.dll) has been enabled in user Reference settings.
And if not set, then set it via VBA

thanks

**rylo** · 03-11-2009, 08:00 PM

Hi

Here's a couple of ways

1)

Please Login or Register  to view this content.

This will loop through the existing references, and if it doesn't find the relelvant one, then it will add it.

2)

Please Login or Register  to view this content.

This "Updates the contents of the COMAddIns collection from the list of add-ins stored in the Windows registry"
Doesn't actually install anything, but I think it "refreshes" the list based on the registry entries.

HTH

rylo

**Leith Ross** · 03-11-2009, 08:10 PM

Hello wotadude,

Here is a macro to automatically check for and load the Shdocvw.dll to your VBA project.

Please Login or Register  to view this content.

**wotadude** · 03-11-2009, 08:33 PM

thank you to you both.

both are good.

**royUK** · 03-12-2009, 02:22 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save