Consulting

Results 1 to 5 of 5

Thread: Help with Embedded Add-In Links in a Spreadsheet

  1. #1
    VBAX Newbie Spiff's Avatar
    Joined
    Nov 2007
    Posts
    3
    Location

    Help with Embedded Add-In Links in a Spreadsheet

    This has probably been asked before, but...

    I've created an Excel Add-In that allows me to do linear or cubic spline interpolation of one- or two-dimensional tables of data. I've found, however, when the spreadsheet is moved to another computer that every occurrence of the add-in also includes the drive and pathname to the add-in of my computer. How can I get the Excel spreadsheet to either automatically carry and install the add-in on the new computer, or see the already installed add-in on the new computer without trying to link back to my computer?

    Help!
    I know you think you know what you thought I said, but I don?t think you realize that what you thought I said isn?t what I really meant.

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,443
    Location
    ____________________________________________
    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
    VBAX Regular
    Joined
    Apr 2008
    Posts
    65
    Location
    Wow! That's brilliant. Thanks so much for the link. I just ran into this problem for the first time two weeks ago. It's only a problem in two cases, as far as I know. First, if one person has created a workbook using my UDF's and then passes the workbook to a second person and, second, if the add-in has moved since the person originally created the workbook.

    Fortunately we don't have many people using it right now and this was discovered during testing. I had been installing the add-in in "Application.UserLibraryPath" but we're switching to an InstallShield install which will create a "Program Files" directory for our add-in so the path will be the same for everyone. Still, these routines would make it almost bullet-proof.

    One thing I didn't understand is where he replaces the xlExcelLinks with the reference to the new location. Doesn't that correct all the formulas at the same time? What's the purpose of replacing the xlExcelLink if he still has to do a replace on each formula? He said he did it "just to be safe".

  4. #4
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,443
    Location
    I would guess that Jan Karel hasn't actually experienced a problem with it, but sees a potential problem, so does it 'just to be safe'.
    ____________________________________________
    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

  5. #5
    VBAX Regular
    Joined
    Apr 2008
    Posts
    65
    Location
    OK. Thanks. The more I think about it the more I think I'd better include this code. We're working on a commercial product and we're doing our best to minimize support calls - in advance. I can see where a company might initially install the add-in in the program files directory on each PC and then later decide to move it to a server. If that happened, all the formulas previously created would stop working.

Posting Permissions

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