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 |
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 |
All times are GMT +1. The time now is 01:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com