refedit controls and Excel 2003 sp3

[Bob Flanagan]

Is anyone having trouble adding refedit controls to userforms after
upgrading 2003 to sp3? I have two pcs, as identical as I can keep them, and
one can not add refedit controls. I get a forms error when I just click on
the control and can not even add one to a form. Repairing office did no
good.

I've seen Bill Freund's posts, and know he is having refedit troubles and he
has not been able to resolve.

I'm wondering if the problem is more wide spread than we think.

Bob Flanagan

 

[Charles Williams]

There does seem to be a major control problem randomly occurring associated
with Excel 2003 SP3.

I have had this problem with both Treeview and Refedit.

Sometimes (but maybe not always) you can solve the problem by searching for
all .EXD files and deleting them.

Sometimes resetting up your profile solves it.

We need to get MSoft to take a look at this

Charles
__________________________________________________
Outlines for my Sessions at the Australia Excel Users Group
http://www.decisionmodels.com/OZEUC.htm

 

[Jon Peltier]

The .EXD files are in the temp directory

C:\Documents and Settings\<username>\Local Settings\Temp

as well as in this directory:

C:\Documents and Settings\<username>\Application Data\Microsoft\Forms

I found that deleting the RefEdit.exd from this second directory fixed the
problem (which first had plagued me for days).

- Jon

 

[Bob Flanagan]

Just deleted all EXD files - no help

Did a repair of Office - no help

Did a re-install per the Control panel - no help

Un-installed Office, searched for and re-deleted all EXD files, deleted all
temp files in application data and Windows, deleted traces of Office still
in Program Files and Application Data, deleted other programs I saw in
Control Panel that didn't belong or were not needed, rebooted, Prayed,
Offered wife to the computer gods, re-installed Office, did not do auto
updates, turned off auto updates to prevent any SP upgrades from
nstalling. - this worked!

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

 

[Jon Peltier]

Your wife must be pretty.

- Jon

 

[Charles Williams]

I have 7 files called Refedit.DLL on my system.

In no particular order they are in
C:\off2003\Office11 12.0.6202.3013 97.8kb created 6 June 2007
C:\off2k\office 1.0.0.0 created 4 June 1998
c:\offxp\Office10 1.0.0.0 created 23 September 1999
C:\WINDOWS\system32 1.0.0.0 61.5 kb created 20 November 1996
C:\program Files\Microsoft Office\Office12 12.0.6211.1000 40.8 kb created 24
August 2007
C:\Windows\Installer\$patchcache$\managed\9040111900063D11C8EF10054038389c\11.0.5614
76.0 kb dated 8 May 2003
C:\Windows\Installer\$patchcache$\managed\000021194100000000000000000F01FEC\12.0.4518
37.2 KB dated 26 October 2006

(I have many different versions of Office coexisting on this system).

What would be interesting would be to get the same list from someone who is
having problems!

Charles
__________________________________________________
Outlines for my Sessions at the Australia Excel Users Group
http://www.decisionmodels.com/OZEUC.htm

 

[Jon Peltier]

Do you know which are registered? Obviously none in the installer cache.

I have three versions in various .cab files (no created date) and one in

C:\Program Files\Microsoft Office 2003\OFFICE11 (1.0.0.0, May 08, 2003)

I had the problem when the SP3 was first installed, but removing the
RefEdit.exd files fixed it for me.

It seems strange that the RefEdit.DLL in your Office11 directory has a
created date of June 2007 and a first numerical entry of 12, not 1.

- Jon

 

[Bob Flanagan]

Jon & Charles, I have one copy in C:\Program Files\Microsoft Office
2003\OFFICE11 and one in C:\Program Files\Microsoft Office 2000\Office as I
have an old copy of Word 2000 installed.

On the one in Office 2003, it has a creation date of 6/6/2007 and the file
version is 12.0.602.3013. On this machine, I get the reference to the
refedit.dll added to a project when I create a refedit control. I then have
to manually delete the reference to avoid headaches.

Bob

 

[Jon Peltier]

The 2007 date and the 12.xxxx version are strange, but the version that
ships with 2007 is October 26, 2006 and 12.0.4518.1014, not June 6, 2007 and
12.0.602.3013.

Removing the reference doesn't cause any problems? I just did a quick test
and it seemed fine, but a quick test doesn't represent substantial real use.

- Jon

 

[Bob Flanagan]

Jon, in my case, leaving the reference causes problems <grin>.

Bob

 

[Jon Peltier]

I was wondering whether you were exchanging one set of problems for another.

I may have found a problem with Excel 2003 userforms with refedits that are
opened in 2007. I got a message about some object not being available, then
the VB editor opened and the refedits were missing from the form. I need to
do more work on this.

- Jon

 

[Glen]

Thank you, thank you, thank you... I did a search for the refedit.exd file,
deleted all references, and a weeks worth of troubleshooting is now over.