add-in detection

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?


--
romes1
------------------------------------------------------------------------
romes1's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15989
View this thread: http://www.excelforum.com/showthread.php?threadid=274572

 

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)


"romes1" <> wrote in message
news:...
>
> 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?
>
>
> --
> romes1
> ------------------------------------------------------------------------
> romes1's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=15989
> View this thread: http://www.excelforum.com/showthread.php?threadid=274572
>

 

Hi romes1,

Try this:

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

inside the Workbook_Open event.


"romes1" wrote:

>
> 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?
>
>
> --
> romes1
> ------------------------------------------------------------------------
> romes1's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15989
> View this thread: http://www.excelforum.com/showthread.php?threadid=274572
>
>