A
Alan Ibbotson
The add-in defines a custom function that returns a catalog price. The
formula in the cell is "=CAT05("1234", Price). When the user that created
the file opens the file, all is well. When another user opens the file we
have problems. Even though all of our users have the same add-in, the file
worksheet will try to reference the creators add-in, i.e. in the non
creators display the cell say "='C:\Documents and Settings\User\Application
Data\Microsoft\AddIns\CustomTools.xla'!CAT05("1234", Price)", where "User"
is the file creator. So the cell returns the "#NAME?" error.
I have been using find and replace to delete the path of the originator and
just display "=CAT05("1234", Price)"[ That gets it to work correctly]. So my
question is what do I need to do, either when the file is created or when it
is reopened, so the path is not inserted into the formula?
formula in the cell is "=CAT05("1234", Price). When the user that created
the file opens the file, all is well. When another user opens the file we
have problems. Even though all of our users have the same add-in, the file
worksheet will try to reference the creators add-in, i.e. in the non
creators display the cell say "='C:\Documents and Settings\User\Application
Data\Microsoft\AddIns\CustomTools.xla'!CAT05("1234", Price)", where "User"
is the file creator. So the cell returns the "#NAME?" error.
I have been using find and replace to delete the path of the originator and
just display "=CAT05("1234", Price)"[ That gets it to work correctly]. So my
question is what do I need to do, either when the file is created or when it
is reopened, so the path is not inserted into the formula?