add-in detection

Discussion in 'Microsoft Excel Programming' started by romes1, Nov 2, 2004.

  1. romes1

    romes1 Guest

    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
     
    romes1, Nov 2, 2004
    #1
    1. Advertisements

  2. romes1

    Bob Phillips Guest

    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
    >
     
    Bob Phillips, Nov 2, 2004
    #2
    1. Advertisements

  3. romes1

    Guest Guest

    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
    >
    >
     
    Guest, Nov 2, 2004
    #3
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Adrian Nightingale

    Automatic detection of a change in a column/cell

    Adrian Nightingale, Sep 1, 2003, in forum: Microsoft Excel Programming
    Replies:
    1
    Views:
    480
    Greg Wilson
    Sep 1, 2003
  2. Chris Gorham

    Detection of VBA code

    Chris Gorham, Nov 1, 2003, in forum: Microsoft Excel Programming
    Replies:
    2
    Views:
    300
    Jim Rech
    Nov 1, 2003
  3. Nigel

    VBA Detection of Workbook already Open

    Nigel, Dec 12, 2003, in forum: Microsoft Excel Programming
    Replies:
    1
    Views:
    629
    Tom Ogilvy
    Dec 12, 2003
  4. George Burdell

    embedded chart vs chartsheet detection

    George Burdell, Mar 20, 2004, in forum: Microsoft Excel Programming
    Replies:
    1
    Views:
    431
    Guest
    Mar 20, 2004
  5. NikkoW

    Another last cell detection problem

    NikkoW, May 5, 2004, in forum: Microsoft Excel Programming
    Replies:
    3
    Views:
    358
  6. Fraggs

    on press detection

    Fraggs, Jun 7, 2004, in forum: Microsoft Excel Programming
    Replies:
    1
    Views:
    284
  7. koo-jii

    Excel programming: change detection

    koo-jii, Oct 20, 2004, in forum: Microsoft Excel Programming
    Replies:
    1
    Views:
    485
    Guest
    Oct 20, 2004
  8. scorpion53061

    Detection of Print Problems

    scorpion53061, Oct 21, 2004, in forum: Microsoft Excel Programming
    Replies:
    1
    Views:
    248
    scorpion53061
    Oct 21, 2004
Loading...