| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
constant reference to an xla function
I'm trying to work out how to constantly reference a certain xla function
without the reference changing when I move the file. I want it always to reference the C:\MSOFFICE\addin.xla!Function() rather no matter what computer the file is on - it always references the users harddrive and this folder. Does anyone have any ideas? Thanks, Steve |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
constant reference to an xla function
I had that problem too. It is a major pain and I found no way around it by
standard user interface. What I did in the end was go to VBA | Tools | References and add a Reference to it from there. Another way is to convert it to an Automation Add-In (Excel 2002 / 2003) -- Rob van Gelder - http://www.vangelder.co.nz/ "Steve" wrote in message ... I'm trying to work out how to constantly reference a certain xla function without the reference changing when I move the file. I want it always to reference the C:\MSOFFICE\addin.xla!Function() rather no matter what computer the file is on - it always references the users harddrive and this folder. Does anyone have any ideas? Thanks, Steve |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reference constant cells in different files from a master workbook | Excel Worksheet Functions | |||
| Reference array constant values in a formula | Excel Discussion (Misc queries) | |||
| Array Constant: How do I reference each value in a formula | New Users to Excel | |||
| How do I set up a constant reference to a cell that moves? | Excel Worksheet Functions | |||
| excel uses what technique to keep a cell reference constant when | Excel Discussion (Misc queries) | |||
Linear Mode
