When Refedit is added to a VBA project as Reference and open in another PC,
We get some Error message. This Error message is due to Missing RefEdit
reference.

Even if RefEdit dll is available in corresponding Path ( Ex. C:\Programs
files\Microsoft Office\office11\RefEdit.dll ). Under Tools - Reference in
the VBA project , We get €œMissing : RefEdit€� control. Once this Reference is
removed and added again by selecting the same Path , then Refedit control
works without any problem.

Is there any problem in RefEdit control in VBA?
Why should Reference be removed and added manually?

What will be the Update that has to done when Office is Upgraded from 2003
to 2007 or to some other version. Will there be the same reference problem
when office version gets modified?

I've had some related problems, which seem to be related to the Office 2003
SP3 update (tho I can't verify this). When I remove the reference without
adding it back in, it mostly seems to work. A client also told me that the
Detect and Repair feature also helps.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Dileep T M" <Dileep T wrote in message
...
When Refedit is added to a VBA project as Reference and open in another
PC,
We get some Error message. This Error message is due to Missing RefEdit
reference.

Even if RefEdit dll is available in corresponding Path ( Ex. C:\Programs
files\Microsoft Office\office11\RefEdit.dll ). Under Tools - Reference in
the VBA project , We get "Missing : RefEdit" control. Once this Reference
is
removed and added again by selecting the same Path , then Refedit control
works without any problem.

Is there any problem in RefEdit control in VBA?
Why should Reference be removed and added manually?

What will be the Update that has to done when Office is Upgraded from 2003
to 2007 or to some other version. Will there be the same reference
problem
when office version gets modified?