Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
RefEdit error message "Element not found"
Hi, I'm using Excel XP and I'm trying to add a RefEdit control to a userform
but I keep getting the error message "Element not found". I've checked under Tools, Additional Controls and the box for "RefEdit.Ctrl" is checked. I'm not sure what else to try. Does anyone know what might be causing this problem? Thanks in advance for any information. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
RefEdit error message "Element not found"
The first time I put a REFEdit control on my PC Added added the Reference
(also under tools) by placing an X. It also told me the library for the reference which is below. Make sure you have the dll and the X is placed in the Reference "Ref Edit Cntl". c:\Program Files\Microsoft Office\Office10\REFEDIT.DLL "FJ" wrote: Hi, I'm using Excel XP and I'm trying to add a RefEdit control to a userform but I keep getting the error message "Element not found". I've checked under Tools, Additional Controls and the box for "RefEdit.Ctrl" is checked. I'm not sure what else to try. Does anyone know what might be causing this problem? Thanks in advance for any information. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
RefEdit error message "Element not found"
Hi, Joel, thanks for your response. I went to Tools, References, browsed for
the RefEdit.DLL and made sure it appeared with a check mark next to it, but I still get the same "Element not found" error message when I try to put a RefEdit control on a userform. Is there anything else I can try? Maybe Excel or all of Office just needs to be reinstalled or something. Thanks in advance for any information. "Joel" wrote: The first time I put a REFEdit control on my PC Added added the Reference (also under tools) by placing an X. It also told me the library for the reference which is below. Make sure you have the dll and the X is placed in the Reference "Ref Edit Cntl". c:\Program Files\Microsoft Office\Office10\REFEDIT.DLL "FJ" wrote: Hi, I'm using Excel XP and I'm trying to add a RefEdit control to a userform but I keep getting the error message "Element not found". I've checked under Tools, Additional Controls and the box for "RefEdit.Ctrl" is checked. I'm not sure what else to try. Does anyone know what might be causing this problem? Thanks in advance for any information. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
RefEdit error message "Element not found"
In the reference the will be a path to the DLL location when yu click on REF
Edit. Make sure you have the DLL in the right location. This DLL location should agree with the one in Additional controls. I went looking for REF Edit on References on my home PC. It wan't ther. I then added a Ref Edit to a user form and went back to the Reference and it appeared. Not sure what that means. My guess is that you may have installed more than one copy of Office on your PC and somehow the newer and old version have pointers set to the wrong copy of the office libraries. You have a library problem that may not get fixed by simply re-installing office or excel. Because libraries are common between many of microsoft products a C compiler or visual Basic installed on your PC could be causing the problem. If you don't know DLL stand for Dynamic Linked Library. If other Controls like Listboxes or Comboboxes are woring then the problem is associated with just the REFEDIT. The REFEDIT may need to be replaced. You should be able to copy this DLL from another PC with the same version of Excel you are using. Using a Window explorer I went to the Office10 directory and right clicked on the REFEDIT.DLL file and check the properties. With Excel 2003 I had version 1.0.0.0 copyright 1993. It doesn't appear that this feature has changed in a real long time. "FJ" wrote: Hi, Joel, thanks for your response. I went to Tools, References, browsed for the RefEdit.DLL and made sure it appeared with a check mark next to it, but I still get the same "Element not found" error message when I try to put a RefEdit control on a userform. Is there anything else I can try? Maybe Excel or all of Office just needs to be reinstalled or something. Thanks in advance for any information. "Joel" wrote: The first time I put a REFEdit control on my PC Added added the Reference (also under tools) by placing an X. It also told me the library for the reference which is below. Make sure you have the dll and the X is placed in the Reference "Ref Edit Cntl". c:\Program Files\Microsoft Office\Office10\REFEDIT.DLL "FJ" wrote: Hi, I'm using Excel XP and I'm trying to add a RefEdit control to a userform but I keep getting the error message "Element not found". I've checked under Tools, Additional Controls and the box for "RefEdit.Ctrl" is checked. I'm not sure what else to try. Does anyone know what might be causing this problem? Thanks in advance for any information. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
RefEdit error message "Element not found"
Hi, Joel, thank you very much for the information. The computer I'm having
the problem with is at work and I think it might have had several different versions of Office installed on it, at least at some point, because there is both an Office 10 folder and an Office 11 folder. So, you might be right that the newer and older versions have pointers set to the wrong the office libraries. Unfortunately, I probably won't be back at work for a few days so I'll have to wait to check it. If I find out what the problem is I will post back here with the information in case anyone else encounters this problem. Thanks again for the detailed information. :) "Joel" wrote: In the reference the will be a path to the DLL location when yu click on REF Edit. Make sure you have the DLL in the right location. This DLL location should agree with the one in Additional controls. I went looking for REF Edit on References on my home PC. It wan't ther. I then added a Ref Edit to a user form and went back to the Reference and it appeared. Not sure what that means. My guess is that you may have installed more than one copy of Office on your PC and somehow the newer and old version have pointers set to the wrong copy of the office libraries. You have a library problem that may not get fixed by simply re-installing office or excel. Because libraries are common between many of microsoft products a C compiler or visual Basic installed on your PC could be causing the problem. If you don't know DLL stand for Dynamic Linked Library. If other Controls like Listboxes or Comboboxes are woring then the problem is associated with just the REFEDIT. The REFEDIT may need to be replaced. You should be able to copy this DLL from another PC with the same version of Excel you are using. Using a Window explorer I went to the Office10 directory and right clicked on the REFEDIT.DLL file and check the properties. With Excel 2003 I had version 1.0.0.0 copyright 1993. It doesn't appear that this feature has changed in a real long time. "FJ" wrote: Hi, Joel, thanks for your response. I went to Tools, References, browsed for the RefEdit.DLL and made sure it appeared with a check mark next to it, but I still get the same "Element not found" error message when I try to put a RefEdit control on a userform. Is there anything else I can try? Maybe Excel or all of Office just needs to be reinstalled or something. Thanks in advance for any information. "Joel" wrote: The first time I put a REFEdit control on my PC Added added the Reference (also under tools) by placing an X. It also told me the library for the reference which is below. Make sure you have the dll and the X is placed in the Reference "Ref Edit Cntl". c:\Program Files\Microsoft Office\Office10\REFEDIT.DLL "FJ" wrote: Hi, I'm using Excel XP and I'm trying to add a RefEdit control to a userform but I keep getting the error message "Element not found". I've checked under Tools, Additional Controls and the box for "RefEdit.Ctrl" is checked. I'm not sure what else to try. Does anyone know what might be causing this problem? Thanks in advance for any information. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
RefEdit error message "Element not found"
FJ -
I have multiple versions of Excel 97-2007 on my Windows XP system. I develop using Excel 97 SR2 and test on more recent versions. I had similar problems when VBA automatically used a modern version of refedit.dll, so now I explicitly use the ancient version of refedit.dll at c:\ windows \ system32. That version shows 62 KB, Date Modified 8/14/97 00:00. - Mike Middleton http://www.DecisionToolworks.com Decision Analysis Add-ins for Excel "FJ" wrote in message ... Hi, Joel, thank you very much for the information. The computer I'm having the problem with is at work and I think it might have had several different versions of Office installed on it, at least at some point, because there is both an Office 10 folder and an Office 11 folder. So, you might be right that the newer and older versions have pointers set to the wrong the office libraries. Unfortunately, I probably won't be back at work for a few days so I'll have to wait to check it. If I find out what the problem is I will post back here with the information in case anyone else encounters this problem. Thanks again for the detailed information. :) "Joel" wrote: In the reference the will be a path to the DLL location when yu click on REF Edit. Make sure you have the DLL in the right location. This DLL location should agree with the one in Additional controls. I went looking for REF Edit on References on my home PC. It wan't ther. I then added a Ref Edit to a user form and went back to the Reference and it appeared. Not sure what that means. My guess is that you may have installed more than one copy of Office on your PC and somehow the newer and old version have pointers set to the wrong copy of the office libraries. You have a library problem that may not get fixed by simply re-installing office or excel. Because libraries are common between many of microsoft products a C compiler or visual Basic installed on your PC could be causing the problem. If you don't know DLL stand for Dynamic Linked Library. If other Controls like Listboxes or Comboboxes are woring then the problem is associated with just the REFEDIT. The REFEDIT may need to be replaced. You should be able to copy this DLL from another PC with the same version of Excel you are using. Using a Window explorer I went to the Office10 directory and right clicked on the REFEDIT.DLL file and check the properties. With Excel 2003 I had version 1.0.0.0 copyright 1993. It doesn't appear that this feature has changed in a real long time. "FJ" wrote: Hi, Joel, thanks for your response. I went to Tools, References, browsed for the RefEdit.DLL and made sure it appeared with a check mark next to it, but I still get the same "Element not found" error message when I try to put a RefEdit control on a userform. Is there anything else I can try? Maybe Excel or all of Office just needs to be reinstalled or something. Thanks in advance for any information. "Joel" wrote: The first time I put a REFEdit control on my PC Added added the Reference (also under tools) by placing an X. It also told me the library for the reference which is below. Make sure you have the dll and the X is placed in the Reference "Ref Edit Cntl". c:\Program Files\Microsoft Office\Office10\REFEDIT.DLL "FJ" wrote: Hi, I'm using Excel XP and I'm trying to add a RefEdit control to a userform but I keep getting the error message "Element not found". I've checked under Tools, Additional Controls and the box for "RefEdit.Ctrl" is checked. I'm not sure what else to try. Does anyone know what might be causing this problem? Thanks in advance for any information. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
RefEdit error message "Element not found"
Hi, Mike, thanks for your response. I will check for that as soon as I
return to work, which will probably be tomorrow, and I'll post back about my results. Thanks again! :) "Mike Middleton" wrote: FJ - I have multiple versions of Excel 97-2007 on my Windows XP system. I develop using Excel 97 SR2 and test on more recent versions. I had similar problems when VBA automatically used a modern version of refedit.dll, so now I explicitly use the ancient version of refedit.dll at c:\ windows \ system32. That version shows 62 KB, Date Modified 8/14/97 00:00. - Mike Middleton http://www.DecisionToolworks.com Decision Analysis Add-ins for Excel "FJ" wrote in message ... Hi, Joel, thank you very much for the information. The computer I'm having the problem with is at work and I think it might have had several different versions of Office installed on it, at least at some point, because there is both an Office 10 folder and an Office 11 folder. So, you might be right that the newer and older versions have pointers set to the wrong the office libraries. Unfortunately, I probably won't be back at work for a few days so I'll have to wait to check it. If I find out what the problem is I will post back here with the information in case anyone else encounters this problem. Thanks again for the detailed information. :) "Joel" wrote: In the reference the will be a path to the DLL location when yu click on REF Edit. Make sure you have the DLL in the right location. This DLL location should agree with the one in Additional controls. I went looking for REF Edit on References on my home PC. It wan't ther. I then added a Ref Edit to a user form and went back to the Reference and it appeared. Not sure what that means. My guess is that you may have installed more than one copy of Office on your PC and somehow the newer and old version have pointers set to the wrong copy of the office libraries. You have a library problem that may not get fixed by simply re-installing office or excel. Because libraries are common between many of microsoft products a C compiler or visual Basic installed on your PC could be causing the problem. If you don't know DLL stand for Dynamic Linked Library. If other Controls like Listboxes or Comboboxes are woring then the problem is associated with just the REFEDIT. The REFEDIT may need to be replaced. You should be able to copy this DLL from another PC with the same version of Excel you are using. Using a Window explorer I went to the Office10 directory and right clicked on the REFEDIT.DLL file and check the properties. With Excel 2003 I had version 1.0.0.0 copyright 1993. It doesn't appear that this feature has changed in a real long time. "FJ" wrote: Hi, Joel, thanks for your response. I went to Tools, References, browsed for the RefEdit.DLL and made sure it appeared with a check mark next to it, but I still get the same "Element not found" error message when I try to put a RefEdit control on a userform. Is there anything else I can try? Maybe Excel or all of Office just needs to be reinstalled or something. Thanks in advance for any information. "Joel" wrote: The first time I put a REFEdit control on my PC Added added the Reference (also under tools) by placing an X. It also told me the library for the reference which is below. Make sure you have the dll and the X is placed in the Reference "Ref Edit Cntl". c:\Program Files\Microsoft Office\Office10\REFEDIT.DLL "FJ" wrote: Hi, I'm using Excel XP and I'm trying to add a RefEdit control to a userform but I keep getting the error message "Element not found". I've checked under Tools, Additional Controls and the box for "RefEdit.Ctrl" is checked. I'm not sure what else to try. Does anyone know what might be causing this problem? Thanks in advance for any information. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XSLT XML Mapping Excel "Map Each Element" "XML Source" | Excel Programming | |||
Why do I receive "Fill not found" message when I open Excel? | Setting up and Configuration of Excel | |||
using % button gives error "percent style not found" Can I reset? | Excel Discussion (Misc queries) | |||
Getting "compile error" "method or data member not found" on reinstall | Excel Programming | |||
"file not found" error message when launching source file | Excel Programming |