Thread
:
Problem with RefEdit Control in VBA
View Single Post
#
2
Posted to microsoft.public.excel.programming
Jon Peltier
external usenet poster
Posts: 6,582
Problem with RefEdit Control in VBA
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?
Reply With Quote
Jon Peltier
View Public Profile
Find all posts by Jon Peltier