User Defined Addin - Urgent Please Help!

  • Thread starter Thread starter Kirit Patel
  • Start date Start date
K

Kirit Patel

I have a addin that i have created using Excel 2000.
Within this addin, there is a user defined function, it
returns a value.

Let us assume the addin is in C:\MyAddin. I then open
this addin. From a blank spreadsheet, i call the user
defined funtion (Insert Function). I then save this
spreadsheet in another directory c:\MyReport. If i shut
the report down and re-open is from c:\MyReport, i get
prompted to re-establish links. How can i avoid this
problem. It only seems to work if the my custom addin and
report reside in the same directory.

Please Help!!!!
 
Kirit,

Usually, if the add-in is still open, you should have no trouble. But
you can try setting a reference to the add-in before you save the
file, using Tools | References ...

HTH,
Bernie
MS Excel MVP
 
Thanks Bernie,

This is what I thought. I thought the whole purpose of an
addin is that you dont need worry about links when calling
functions within it. I have tried in the report workbook
to set a reference but that does't seem to help either?

Any more ideas anyone...
 
Kirit Patel -
I have a addin that i have created using Excel 2000. Within this addin,
Click to expand...
there is a user defined function, it returns a value. Let us assume the
addin is in C:\MyAddin. I then open this addin. From a blank spreadsheet,
i call the user defined funtion (Insert Function). I then save this
spreadsheet in another directory c:\MyReport. If i shut the report down and
re-open is from c:\MyReport, i get prompted to re-establish links. How can
i avoid this problem. It only seems to work if the my custom addin and
report reside in the same directory. <

I don't think there's any way to avoid this problem (unless maybe if your
function is a DLL instead of VBA). What you're seeing is standard behavior
for an add-in user defined function. Look at the cell containing your
function (after you open the workbook without the add-in open), and you'll
see that Excel saves the specific path to where the add-in resided when you
entered the function. I usually advise my users to open such a workbook by
answering No for re-establishing links and then use Edit | Links to
explicitly change the source to the open add-in.

- Mike Middleton, www.usfca.edu/~middleton
 
Thanks Mike for your time...

-----Original Message-----
Kirit Patel -
Within this addin,
there is a user defined function, it returns a value. Let us assume the
addin is in C:\MyAddin. I then open this addin. From a blank spreadsheet,
i call the user defined funtion (Insert Function). I then save this
spreadsheet in another directory c:\MyReport. If i shut the report down and
re-open is from c:\MyReport, i get prompted to re- establish links. How can
i avoid this problem. It only seems to work if the my custom addin and
report reside in the same directory. <

I don't think there's any way to avoid this problem (unless maybe if your
function is a DLL instead of VBA). What you're seeing is standard behavior
for an add-in user defined function. Look at the cell containing your
function (after you open the workbook without the add-in open), and you'll
see that Excel saves the specific path to where the add- in resided when you
entered the function. I usually advise my users to open such a workbook by
answering No for re-establishing links and then use Edit | Links to
explicitly change the source to the open add-in.

- Mike Middleton, www.usfca.edu/~middleton


.
Click to expand...
 
Back
Top