+ Reply to Thread
Results 1 to 13 of 13

Add-in referanceing issues

  1. #1
    Forum Contributor
    Join Date
    09-21-2012
    Location
    illinois
    MS-Off Ver
    Excel 2010
    Posts
    242

    Add-in referanceing issues

    I'm haveing an issue with how functions in my spreadsheet are referanceing the addi-in I created. I have created an add-in and placed it in the add-in directory on my computer. The problem is that if I open a document on another computer on the network that was saved on my computer everywhere that functions in the add-in is referanced the path for my add-in is there so it will not work. Any ideas how ot stop this?

  2. #2
    Valued Forum Contributor
    Join Date
    03-17-2012
    Location
    Warsaw, Poland
    MS-Off Ver
    2007/2010
    Posts
    555

    Re: Add-in referanceing issues

    This is normal behavior of excel. Either have the add-in installed on every pc you're accessing the file or place the UDF's in the file itself.
    If you think that my answer was helpful, please click on the "Add to this user's Reputation" button.

  3. #3
    Forum Contributor
    Join Date
    09-21-2012
    Location
    illinois
    MS-Off Ver
    Excel 2010
    Posts
    242

    Re: Add-in referanceing issues

    I have saved the add-in file in the add-in directory and selected it in options/add-in on all the PC's that are using it and they all referance my directory for the add-in on the worksheet. How can I make it so they referance the addin on there workstation?

  4. #4
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Add-in referanceing issues

    put the add-in in a central location and have everyone instal it from there without copying it locally. also make it read only in case you need to update it
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  5. #5
    Forum Contributor
    Join Date
    09-21-2012
    Location
    illinois
    MS-Off Ver
    Excel 2010
    Posts
    242

    Re: Add-in referanceing issues

    I would love to do that I have a xlam file. How would I reverance it? everything I read refers to doingit localy.

  6. #6
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Add-in referanceing issues

    installation and usage is the same but you must choose no when asked if you want to copy the add-in file locally

  7. #7
    Forum Contributor
    Join Date
    09-21-2012
    Location
    illinois
    MS-Off Ver
    Excel 2010
    Posts
    242

    Re: Add-in referanceing issues

    I think I'm doing it differantly. I take the QUOTE.xlam file and copy it to C:\Users\tec.CRVELECT\AppData\Roaming\Microsoft\AddIns. Then I go to file>options>Add-Ins>Manage and select the checkbox for the add-in I just put in the directory. I am using EXCEL 2010. Is there a better way these arer the instructions I fund online.

  8. #8
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Add-in referanceing issues

    don't copy the file locally-use the browse button in the add-ins dialog to locate the file on the network

  9. #9
    Forum Contributor
    Join Date
    09-21-2012
    Location
    illinois
    MS-Off Ver
    Excel 2010
    Posts
    242

    Re: Add-in referanceing issues

    You are the best. The absolute best.

  10. #10
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Add-in referanceing issues

    glad to help :-)

  11. #11
    Forum Contributor
    Join Date
    09-21-2012
    Location
    illinois
    MS-Off Ver
    Excel 2010
    Posts
    242

    Re: Add-in referanceing issues

    Joseph,

    I am having issues with my add-in. It is not executing the code the is for a worksheet it only executes it if it is in the work book. for example Private Sub Worksheet_Change(ByVal Target As Excel.Range) is not getting executed. How can I fix this?

  12. #12
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Add-in referanceing issues

    if that code is in a sheet in the add-in it will only respond to changes in that sheet. perhaps you want application level events-see Chip Pearson's web site

  13. #13
    Forum Contributor
    Join Date
    09-21-2012
    Location
    illinois
    MS-Off Ver
    Excel 2010
    Posts
    242

    Re: Add-in referanceing issues

    OK thanks for the help.

+ 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