| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why full path in the formula to an UDF function?
I have a project, which uses UDFs, running in several computers. When I open the file in computer 1, after I saved it in computer 2, the call to a formula in a cell is proceded by the full path to the UDF, where the full path points to the path in computer 2, where it was saved (Extremely clearly described;)).
E.g. ='C:\Users\HBJ\AppData\Roaming\Microsoft\AddIns\HB JUDF.xlam'!MyFunc(xxx,yyy) HBJUDF.xlam is located in a common directory (Dropbox) accessible from all computers. How should I reference the UDF to prevent it to load into the local AddIns directory? How can I prevent Excel from adding full path name to the function call? Thank you in advance! HÃ¥kan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using 'indirect' function with full network path | Excel Worksheet Functions | |||
| Using 'indirect' function with full network path | Excel Discussion (Misc queries) | |||
| Full path possible to be seen? | New Users to Excel | |||
| Full path in title bar | Excel Discussion (Misc queries) | |||
| Syntax for using the full path to get a value | Excel Programming | |||
Threaded Mode
