add-in detection

  • Thread starter Thread starter romes1
  • Start date Start date
R

romes1

I want to send a workbook to another person who probably won't have the
Analysis Toolpak or Analysis Toolpak - VBA open but will need these to
be for the book to work. How can I check to see if they have it open
and if not, open it on their computer inside the OnOpen event of my
book?
 
If AddIns("myAddin").Installed = False Then
Application.AddIns.Add Filename:="C:\myAddin.xla"
End If

you may need to amedn the addin path

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Hi romes1,

Try this:

Addins("Analysis Toolpak").Installed = True
Addins("Analysis Toolpak - VBA").Installed = True

inside the Workbook_Open event.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MRound 7
Code to install Analysis ToolPak at Workbook Open 2
An issue with "References" in VBA 6
Check for Addin before Update Links 2
analysis toolpak problem 2
Analysis Toolpak - VBA add-in 2
Update Links, Scheduled Tasks and UDFs 2
EOMONTH compatibility issue (workaround?) 1

Back
Top