PDA

View Full Version : refedit control - class not registered



philfer
10-04-2010, 02:37 AM
Hello,

I have a form with a refedit control that works fine on my pc.

When a different person tries to open it on their pc it says "Object not found"

I then go into the VBE and right click the toolbox and check the refedit control (for some reason this user has two - although one gets added to the toolbox as unknown).

I then try to add the working refedit control to the form and it gives me the class not registered error

I got an IT man to log on as administrator and run :-

regsvr "C:\Program Files\Microsoft Office\Office12\REFEDIT.DLL

and they got a success message

When I logged back on as the user the same problem existed

Any advice chaps?

Cheers
Phil

Kenneth Hobs
10-04-2010, 07:16 AM
Did you check that you are both running Excel 2003?

The Application.Inputbox might be a better route.

philfer
10-04-2010, 09:58 AM
Hello,

We are both using Excel 2007.

The Application.Inputbox is a good idea. The thing I liked about using the RefEdit was that I could handle the user clicking a row/cell or typing in the row number (it was being used to delete rows!)

For me I like to figure out why things are happening as well, especially when things should be happening that arent!

Any input would be gratefully received
Phil

Kenneth Hobs
10-04-2010, 10:21 AM
You have a conflict. Remove the check in the references if it is there and the control from the toolbox. This was discussed at: http://www.excelforum.com/excel-programming/681338-error-in-loading-dll.html