Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have tried to run some code including a user form and get an error message
relating to error loading a .dll file. I have looked in the References and there is an entry Missing RefEdit. I have reinsatlled the file Refedit.dll but still get the error message. Any and all help will be much appreciated. Regards & TIA __________ Information from ESET NOD32 Antivirus, version of virus signature database 4589 (20091109) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
When you go to the References and see the "Missing" message... there should
be an unchecked CheckBox next to it... try putting a check mark in it and then hitting the OK button. -- Rick (MVP - Excel) "Jim" wrote in message ... I have tried to run some code including a user form and get an error message relating to error loading a .dll file. I have looked in the References and there is an entry Missing RefEdit. I have reinsatlled the file Refedit.dll but still get the error message. Any and all help will be much appreciated. Regards & TIA __________ Information from ESET NOD32 Antivirus, version of virus signature database 4589 (20091109) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Sorry - I should have mentioned in my original post that the check box is
ticked. Could this be a problem with different versions ? I am using a fresh install of Office 2003 Windows XP Home edition "Rick Rothstein" wrote in message ... When you go to the References and see the "Missing" message... there should be an unchecked CheckBox next to it... try putting a check mark in it and then hitting the OK button. -- Rick (MVP - Excel) "Jim" wrote in message ... I have tried to run some code including a user form and get an error message relating to error loading a .dll file. I have looked in the References and there is an entry Missing RefEdit. I have reinsatlled the file Refedit.dll but still get the error message. Any and all help will be much appreciated. Regards & TIA __________ Information from ESET NOD32 Antivirus, version of virus signature database 4589 (20091109) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com __________ Information from ESET NOD32 Antivirus, version of virus signature database 4589 (20091109) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com __________ Information from ESET NOD32 Antivirus, version of virus signature database 4589 (20091109) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
This problem happens frequently these days. If a project has a MISSING
RefEdit.dll, uncheck the box, compile the code, save and close the workbook. Then go to Help menu Detect and Repair and let Excel try to heal itself. These steps will usually solve the problem. If not you have to get some chicken's blood and wait for full moon. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Jim wrote: I have tried to run some code including a user form and get an error message relating to error loading a .dll file. I have looked in the References and there is an entry Missing RefEdit. I have reinsatlled the file Refedit.dll but still get the error message. Any and all help will be much appreciated. Regards & TIA __________ Information from ESET NOD32 Antivirus, version of virus signature database 4589 (20091109) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
On Nov 11 2009, 10:33*am, Jon Peltier
wrote: This problem happens frequently these days. If a project has a MISSING RefEdit.dll, uncheck the box, compile the code, save and close the workbook. Then go to Help menu Detect and Repair and let Excel try to heal itself.. These steps will usually solve the problem. If not you have to get some chicken's blood and wait for full moon. - Jon ------- Jon Peltier Peltier Technical Services, Inc.http://peltiertech.com/ Jim wrote: I have tried to run some code including a user form and get an error message relating to error loading a .dll file. I have looked in the References and there is an entry Missing RefEdit. I have reinsatlled the file Refedit.dll but still get the error message. Any and all help will be much appreciated. Regards & TIA __________ Information from ESET NOD32 Antivirus, version of virus signature database 4589 (20091109) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com I used Jon Peltier's solution with a small change. I looked and made sure the RefEdit.dll file was where it was supposed to be, it was, then I unchecked the box for the "Missing Ref Edit Control" and compiled the code. I then opened References and rechecked RefEdit.dll and re-compiled the code. It worked for me. Good luck and you can save the chicken blood for the next problem. John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
To refedit, or not to refedit, that is the question. | Excel Programming | |||
Help needed with a RefEdit control | Excel Programming | |||
ActiveX Plugin needed in Excel 2000 missing from Excel 2003 | Excel Programming | |||
On Error? Creates 1 missing worksheet then never detects any other missing worksheets | Excel Programming | |||
RefEdit in VB6 | Excel Programming |