Check For Add-in
 

Hello
I have created a file that uses Longre's morefunc. I have the .xll
located in the same directory as the file. How do I check that my
user's also have the add-in enables and if not, enable it for them?
Thanks!
Steve

Check For Add-in
 

How about just setting a reference to morefunc in your workbook's project.

Inside the VBE (with both workbooks open and your workbook's project active)
tools|references
check the project associated with MoreFunc

Each time your workbook opens, the addin will also open.



Steve H wrote:

Hello
I have created a file that uses Longre's morefunc. I have the .xll
located in the same directory as the file. How do I check that my
user's also have the add-in enables and if not, enable it for them?
Thanks!
Steve

--

Dave Peterson

Check For Add-in
 

I presume that you mean the morefunc.xls workbook and my work book? If
so when I check it in the reference box I get "Name conflicts with
existing module, project or object library"
Thanks!

Dave Peterson wrote:
How about just setting a reference to morefunc in your workbook's project.

Inside the VBE (with both workbooks open and your workbook's project active)
tools|references
check the project associated with MoreFunc

Each time your workbook opens, the addin will also open.



Steve H wrote:

Hello
I have created a file that uses Longre's morefunc. I have the .xll
located in the same directory as the file. How do I check that my
user's also have the add-in enables and if not, enable it for them?
Thanks!
Steve

--

Dave Peterson

Check For Add-in
 

I answered too quickly. I thought that the morefunc was a simple .xla. It's
not.

Sorry, I don't know the answer.



Steve H wrote:

I presume that you mean the morefunc.xls workbook and my work book? If
so when I check it in the reference box I get "Name conflicts with
existing module, project or object library"
Thanks!

Dave Peterson wrote:
How about just setting a reference to morefunc in your workbook's project.

Inside the VBE (with both workbooks open and your workbook's project active)
tools|references
check the project associated with MoreFunc

Each time your workbook opens, the addin will also open.



Steve H wrote:

Hello
I have created a file that uses Longre's morefunc. I have the .xll
located in the same directory as the file. How do I check that my
user's also have the add-in enables and if not, enable it for them?
Thanks!
Steve

--

Dave Peterson

--

Dave Peterson