Refedit issue

[Djblois]

Some of my users are having an issue that says they are missing refedit. I go into the references library and add browse to it and add it manually but I still get that error when I try to run vba on the system. This is on a server. Does anyone know how to fix this issue?

[Kenneth Hobs]

Typically, it is in c:\Program Files\Microsoft Office\Office11\RefEdit.dll for v2003. You may need to run RegSvr32 to install it.

e.g.
Start > Run > RegSvr32 "c:\Program files\MicroSoft Office\Office11\RefEdit.dll"

[Djblois]

Here are a few more points to help diagnose the problem.

1) we are using excel 2007
2) My company is testing out the x64 version of Windows Server 2003 and anyone on there has that issue. And only those people have the issue
3) Kenneth I tried that and it doesn't help

[Norie]

Daniel

Have you considered not using the RefEdit control?

If you need to select a range then you could perhaps use Application.Inputbox.