1 New Message
Digest #2953
Message
Sat Feb 1, 2014 12:59 pm (PST) . Posted by:
"Randy Harmelink" rharmelink
When EXCEL saves a workbook, it hard-codes the location of the add-in on
each and every function.
When EXCEL opens a workbook, it sees that hard-coded location and looks for
the add-in in that location. If it finds it there, AND that is the location
the add-in manager says it should be, it removes the hard-coded location
that was part of the function (i.e. it "resolves the link"). If it can't
find the add-in in the hard-coded location, or that location is not where
the add-in manager says the function should be, it leaves the path on the
function (i.e. an "unresolved link").
I have had several people tell me EXCEL gets "confused"; at some point. For
them, freefaller6's suggestion seems to fix things. That is:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/14672
On Sat, Feb 1, 2014 at 10:25 AM, <climbermel@gmail.com> wrote:
> For some time I 've had trouble with the hard coding issue of Excel. It
> only takes a second to fix now, but I would still like to try and resolve
> WHY it still does it. The problem is when I open a sheet that was opened
> on a different computer, it can't find the addin. Is there something in
> the code that picks which drive to look for the AddIn? It resides in
> C:\Program Files\SMF Add-in on both machines, but it used to be in
> U:\Program Files\SMF Add-in (my User drive). I opens fine every time on
> the other machine, but frequently it still seems to be looking for
> U:\Program Files\SMF Add-in. I could place a copy there, but I'd rather
> understand WHY it is doing this. When I open a sheet, I can just point it
> to the C: folder and continue. I have also used the replace all to remove
> the hard coded location and that works as well.
>
> I have also looked through the registry and can't find why it keeps
> thinking it should be on U:
>
each and every function.
When EXCEL opens a workbook, it sees that hard-coded location and looks for
the add-in in that location. If it finds it there, AND that is the location
the add-in manager says it should be, it removes the hard-coded location
that was part of the function (i.e. it "resolves the link"). If it can't
find the add-in in the hard-coded location, or that location is not where
the add-in manager says the function should be, it leaves the path on the
function (i.e. an "unresolved link").
I have had several people tell me EXCEL gets "confused"
them, freefaller6&#
https://groups.
On Sat, Feb 1, 2014 at 10:25 AM, <climbermel@gmail.
> For some time I 've had trouble with the hard coding issue of Excel. It
> only takes a second to fix now, but I would still like to try and resolve
> WHY it still does it. The problem is when I open a sheet that was opened
> on a different computer, it can't find the addin. Is there something in
> the code that picks which drive to look for the AddIn? It resides in
> C:\Program Files\SMF Add-in on both machines, but it used to be in
> U:\Program Files\SMF Add-in (my User drive). I opens fine every time on
> the other machine, but frequently it still seems to be looking for
> U:\Program Files\SMF Add-in. I could place a copy there, but I'd rather
> understand WHY it is doing this. When I open a sheet, I can just point it
> to the C: folder and continue. I have also used the replace all to remove
> the hard coded location and that works as well.
>
> I have also looked through the registry and can't find why it keeps
> thinking it should be on U:
>
Tidak ada komentar:
Posting Komentar