REF EDIT Control

[Pauljj]

I am racking my brains trying to find a solution here. I have a workbook which contains amongst other things a userform

Now I have a missing file which is RefEdit control

I have tried unticking it and get various Error in loading DLL messages

I have tried re-installing office

I have tried browsing back to where the RefEdit.dll file is

I have tried deleting the file and copying it from another machine back to mine

and nothing, still stays the same. Even when I unclick the missing file, everytime I go back to it, it's still there....anyone any ideas please ?

 

[Kenneth Hobson]

You are probably using 64 bit or a newer version of Excel. Delete your control and then uncheck it. You can use something like this instead. http://peltiertech.com/WordPress/refedit-control-alternative/

 

[Pauljj]

I've tried deleting the refedit.dll and unchecking it but that doesn't work. It then comes up error loading dll

I seem to be going around in circle

 

[Pauljj]

I am using excel 2003 by the way

 

[Jon Peltier]

Look for and delete the RefEdit.exd file (not the dll). On my machine (Windows 7, 64-bit) it's located here:

C:\Users\Jon\AppData\Roaming\Microsoft\Forms

 

[Pauljj]

Hello Jon, thanks for your reply. I have deleted the file you mention. I then went to open the workbook and it said Error in loading dll. I then went to the vba window to unclick the missing refedit.dll and and the same error message re-appears not allowing me to unlick it.

I even tried to delete the form I created...despite it taking hours to create and it won't even let me delete the form .....very puzzled

 

[Jon Peltier]

If you've deleted the dll, of course it won't work. Reinstall that, and without the .exd file, it should behave.

I'm worrying though that your file has become corrupted. Try using Rob Bovey's Code Cleaner (free from http://appspro.com), which may take care of VBA corruption.

 

[Pauljj]

I think the file is corrupt, I can't save the document, the cleaner won't work on it. It now looks as if my 2 weeks of work will have to be started again .........

 

[Pauljj]

My problem with this is I don't know what caused it and I don't know how to stop it from happening in future. I can't delete the form, essentially I can't do anything to this file. If I start from scratch, is it going to happen all over again ?

 

[Jon Peltier]

Starting from scratch should include a complete uninstall, then kill all temp files (including any and all Office .exd files you can find), then reinstall.

I don't know what caused the problem, but deleting the dll and copying another dll from a working computer in this case brought me no joy when I encountered the problem a couple of years ago.

Keeping files simple, starting from scratch when designing a new dialog, using a code cleaner frequently. Things like this may help, but the RefEdit is inherently difficult, especially across versions of Excel. I don't use it in commercial add-ins, even though when it works it's much better than any alternatives.