full path in front of formulars

  • Thread starter Thread starter Lars Schouw
  • Start date Start date
L

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
 
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!
 
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?????
 
Back
Top