PDA

View Full Version : Refedit issue



Djblois
10-13-2008, 09:18 AM
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
10-13-2008, 09:48 AM
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
10-13-2008, 10:55 AM
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
10-13-2008, 11:32 AM
Daniel

Have you considered not using the RefEdit control?

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