Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Defined Addin - Urgent Please Help!
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!!!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Defined Addin - Urgent 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 "Kirit Patel" wrote in message ... 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!!!! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Defined Addin - Urgent Please Help!
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... -----Original Message----- 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 "Kirit Patel" wrote in message ... 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!!!! . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Defined Addin - Urgent Please Help!
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. < 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
User Defined Addin - Urgent Please Help!
Thanks Mike for your time...
-----Original Message----- 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. < 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Message "user defined type not defined" | Excel Discussion (Misc queries) | |||
Urgent Pls, how to convert an addin xlam file to xls worksheet in | Excel Discussion (Misc queries) | |||
Urgent new user needs Macro HELP! | Excel Worksheet Functions | |||
How do I edit a worksheet that has been defined as an addin | Excel Discussion (Misc queries) | |||
"User-defined type not defined" message in Excel | Excel Discussion (Misc queries) |