full path in front of formulars

[Lars Schouw]

How come Excel sometimes inserts full paths in front of foamulars? I
mostly saw this with VBA addins.

e.g.
'C:\Program Files\Microsoft Office 2003\Office11\Library\myaddib.xla'!
foo()

Regards,
Lars Schouw

 

[Dave Peterson]

Is that addin installed (tools|addins) and is it checked in that same dialog?

 

[Lars Schouw]

Yes, it mostly hapens when we move the sheet from one machine to
another.
We then have to goto tools->edit and restable the link to the addin
for ALL sheets!

 

[Dave Peterson]

Is the addin in the exact same location for each pc?

If the location varies with different pcs, maybe it's time to move the addin to
a common network location and have the users install that addin using the UNC
path (not mapped drive letter).

Or make sure the addin is in a location with the same name:

C:\LarsUtils\myaddib.xla

For each and every user.

ps. myaddib?????

 

[Lars Schouw]

This kb could be helpfull I am checking now..

http://support.microsoft.com/kb/328440