Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User defined function
Hi Group,
I have several User Defined Functions, but they were created years ago. I an not find what file they reside in anymore. There is not a persoanl.xls in the startup menu, which is where I thought it would be. Any ideas in trying to figure out where they are? I have tried a search using one of the Functions names "HTLMConvert" with no luck. I would like to find out where these reside. Thanks, David |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
User defined function
Assuming that these functions are not workbook specific then my best guess
would be that they are in an addin. When you open the VBE you will get a listing of all of the open workbooks and addins. -- HTH... Jim Thomlinson "David" wrote: Hi Group, I have several User Defined Functions, but they were created years ago. I an not find what file they reside in anymore. There is not a persoanl.xls in the startup menu, which is where I thought it would be. Any ideas in trying to figure out where they are? I have tried a search using one of the Functions names "HTLMConvert" with no luck. I would like to find out where these reside. Thanks, David |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
User defined function
Hi Jim,
I went to the VBE and took a look and do not see anything. I used the add-in manger and found nothing there. I do get a list when I go to the Function Insert f* and these seem to be available all of the time. They must come from some file, yes? Is there a way from the f* to ID their source? I could not see a way and I do not know how many files I have, but many. The list I get is: Accrint CopyFileTemplate GetDivID HTMLConvert IsShared Thanks, David "Jim Thomlinson" wrote: Assuming that these functions are not workbook specific then my best guess would be that they are in an addin. When you open the VBE you will get a listing of all of the open workbooks and addins. -- HTH... Jim Thomlinson "David" wrote: Hi Group, I have several User Defined Functions, but they were created years ago. I an not find what file they reside in anymore. There is not a persoanl.xls in the startup menu, which is where I thought it would be. Any ideas in trying to figure out where they are? I have tried a search using one of the Functions names "HTLMConvert" with no luck. I would like to find out where these reside. Thanks, David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using dcount function within user-defined worksheet function | Excel Programming | |||
Excel - User Defined Function Error: This function takes no argume | Excel Programming | |||
Need to open the Function Arguments window from VBA for a user defined function. | Excel Programming | |||
User-defined data type; Error: Only User-defined types... | Excel Programming | |||
User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming |