P
Philippon
Hello,
I want to share some functions with other users.
I use an add-in that I send to them.
One of the function is declared as :
public function Whatever(x as integer) as integer
The other users manage to use the function in their own spreadsheets
but when I use the function in my spreadsheet and open it on an othe
computer, the function does not work and give an error message.
Indeed, the path in the cell using the function has been changed t
='C:\Documents and Settings\THE_USER_COMPUTER\Applicatio
Data\Microsoft\AddIns\THE_ADD_IN_NAME.xla'!Whatever(...)
From what I understand, the path used is the one that locates th
add-in on the original computer. Is there a way to avoid that and hav
=Whatever(...) even if the worksheet has not been created on thi
computer ?
Many thanks for your help
I want to share some functions with other users.
I use an add-in that I send to them.
One of the function is declared as :
public function Whatever(x as integer) as integer
The other users manage to use the function in their own spreadsheets
but when I use the function in my spreadsheet and open it on an othe
computer, the function does not work and give an error message.
Indeed, the path in the cell using the function has been changed t
='C:\Documents and Settings\THE_USER_COMPUTER\Applicatio
Data\Microsoft\AddIns\THE_ADD_IN_NAME.xla'!Whatever(...)
From what I understand, the path used is the one that locates th
add-in on the original computer. Is there a way to avoid that and hav
=Whatever(...) even if the worksheet has not been created on thi
computer ?
Many thanks for your help