B
Brian K. Sheperd
I needed to access a MS Access database to extract a unit cost that matches
a part number that was in Excel. I created a function, saved it as an XLA,
and used it as an Add-in. I figured that I could copy the XLA file to the
users profile (c:\documents and settings\user\application
data\microsoft\addins), and then when another user opened the file, the
function would work. As it turns out, it looks like when another user opens
the file, it is trying to access my profile for the function. So, I figured
that I would put the XLA file on a shared network folder. Browsed to the
addin (did not copy to local HD), and then resaved the spreadsheet. I
opened the file on a different machine (that has access to the network
folder), but it still wasn't working. Is there a way to get this to work?
Or do I have to save the function in the actual file?
Thanks,
Brian
a part number that was in Excel. I created a function, saved it as an XLA,
and used it as an Add-in. I figured that I could copy the XLA file to the
users profile (c:\documents and settings\user\application
data\microsoft\addins), and then when another user opened the file, the
function would work. As it turns out, it looks like when another user opens
the file, it is trying to access my profile for the function. So, I figured
that I would put the XLA file on a shared network folder. Browsed to the
addin (did not copy to local HD), and then resaved the spreadsheet. I
opened the file on a different machine (that has access to the network
folder), but it still wasn't working. Is there a way to get this to work?
Or do I have to save the function in the actual file?
Thanks,
Brian