+ Reply to Thread
Results 1 to 4 of 4

Register DIY add-in

  1. #1
    Registered User
    Join Date
    08-31-2004
    Posts
    17

    Register DIY add-in

    I developed a few functions in an Excel add-in and distribute the add-in to my collegues at work. I found after a user used a function from his/her loaded add-in in a workbook, when another user open the workbook he/she will see Excel add the path of the add-in file the original user installed to the function, even though the new user also has the add-in installed.

    What I want is when another user with same add-in installed he/she won't see the path of original user's add-in file shown in the workbook. How can I get rid of this problem in DIY add-in? I assume it may involve registering my add-in in windows but I don't how.

    Any answer or direction will be appreciated.

    Huyeote

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello Huyeote,

    If I understand your post, the add-in's location is showing up in Excel's MRU (Most Recently Used) file list. If this is the case then your Add-In is not located in the proper folder. Saving the wprkbook as .xla won't place it in the correct folder.

    Add-In folder path: C:\Documents and Settings\ <user name>\ Application Data\Microsoft\AddIns

    After the Add-In is selected from the Add-In list from the Tools menu, the location will remain hidden.

    Sincerely,
    Leith Ross

  3. #3
    Registered User
    Join Date
    08-31-2004
    Posts
    17
    Thank you Leith, but my problem is different. I have rountine in the add-in file to install the .xla file user's personal add-in folder just as you wrote.

    To elaborate, imagine you are using a function from Excel's Analysis ToolPak add-in in a workbook. When another user open the workbook, what he/she sees is just that function in the cell provided he/she has same add-in installed. My problem is after a user A uses a DIY function from my add-in in a workbook, even if user B also has my add-in properly installed, what B sees in the workbook is the full path of user A's add-in file before that function rather than a simple function.

    How can I acheive the same result as those add-in from MS?

    Cheers,

    Huyeote

  4. #4
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258
    Hello Huyeote,

    I understand now what you mean. Since you have established a link bewteen workbooks by using one of the Add-In's functions, Excel will naturely show that link. How MS prevents that, I really don't know. I would have to research that to give you an answer. Very interesting post.

    Sincerely,
    Leith Ross

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1