Macro to add/install a reference in VBA

[phantom1975]

I have looked everywhere I can and I am unable to find a solution. I have an add-in that I created installed. Cool! The problem I am having is that when I open a workbook, I would like to be able to use the functions and macros in the add-in. No problem! I understand that I have to set a reference to the add-in (even though it is installed) in order to use the functions and macros. No biggie, I set a reference to the add-in and everything works beautifully.

HERE'S THE PROBLEM: I have to manually set the reference each time I open a new workbook. I have about a dozen workbooks that I need to reference this add-in. The trick is that I will be giving many people these workbooks and need to make sure that they all also reference the add-in. Without getting to long-winded, all I am looking for is a macro that will check if a reference exists and if it is activated. If it doesn't exist, it will be added (every user will have a copy of the add-in installed and it is in the same directory on every computer.) If the reference does exist, but it is not activated, I need to have it activated.

I love you.

 

[mjbeam]

Check out this URL:

http://xcelfiles.homestead.com/WhatsUpClass.html

Scroll down to the section about late binding.


-Mike

 

[Andrew Poulsom]

To programatically add a reference use code like this:

ThisWorkbook.VBProject.References.AddFromFile "C:\AddIns\MyAddIn.xla"

 

[phantom1975]

To programatically add a reference use code like this:

ThisWorkbook.VBProject.References.AddFromFile "C:\AddIns\MyAddIn.xla"

I'm sure that this is what I am looking for. When I run it though, I get the following:

Run-time error 1004:

Programmatic access to Visual Basic Project is not trusted.

Do I need to take them out to dinner a few times first?

 

[Andrew Poulsom]

Look here:

http://j-walk.com/ss/excel/tips/tip96.htm

 

[phantom1975]

Look here:

http://j-walk.com/ss/excel/tips/tip96.htm

Andrew, you complete me. That did the trick.