Can User-defined functions be written so that they will work on every computer on a network?
I wrote a function called "Address1" that returns the street address for a customer. (Of course, I have Address2 and so forth...my application prints checks.) We don't have a server, so common files are stored in a "Common Area" folder on one of the computers with peer-to-peer file sharing. The Address1 function is in an xla file in the "Common Area" folder. Excel on every computer is setup to load the xla.
Here's what happens:
Any user can enter the function in a cell ("=Address1("customer")) and it works fine. HOWEVER, if the file is saved and reopend by a different computer on the network, the path to the function is inserted in the cell ("=/path info/Common Area/Address1("customer")) and the function does not work.
Is there a solution short of writing an automation add-in?