Consulting

Results 1 to 3 of 3

Thread: Install addin for everyone

  1. #1
    VBAX Master
    Joined
    Jun 2006
    Posts
    1,091
    Location

    Install addin for everyone

    I just found this directory in one of my books:

    officedirectory\office\library

    From what I read I think what ever installs there would install for everyone using Excel on the server. Is that right?

    Also, if it is right - how do I find it? I have tried to find it and it is not there?

    I am using Excel 2007 on a server.

    I am trying to get it so I can update my program without the user having to each time. Right now people are getting errors that I already fixed because they do not bother to update the program until I force them to.
    Thank You,
    Daniel Blois
    http://studenthacker.blogspot.com/

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    I know of no way to install something automatically on all desktops. The best I could do was to have th addin on a server and install it from there, as long as the server has a universal drive lettere in the organisation. But that still requires installing the addin on Excel on each machine.

    Maybe it means put your addin in the XLStart directory as that will get it opened when Excel starts up.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    Administrator
    VP-Knowledge Base
    VBAX Grand Master mdmackillop's Avatar
    Joined
    May 2004
    Location
    Scotland
    Posts
    14,489
    Location
    If the add-in is for a specific workbook, you could add code to that to open/close the add-in. If consider NOT copying it to the local PC, this means you have only the server copy to maintain.
    MVP (Excel 2008-2010)

    Post a workbook with sample data and layout if you want a quicker solution.


    To help indent your macros try Smart Indent

    Please remember to mark threads 'Solved'

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •