Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
refedit controls and Excel 2003 sp3
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
refedit controls and Excel 2003 sp3
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 "Bob Flanagan" wrote in message . .. 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
refedit controls and Excel 2003 sp3
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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Charles Williams" wrote in message ... 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 "Bob Flanagan" wrote in message . .. 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
refedit controls and Excel 2003 sp3
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" wrote in message ... 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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Charles Williams" wrote in message ... 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 "Bob Flanagan" wrote in message . .. 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
refedit controls and Excel 2003 sp3
Your wife must be pretty.
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Bob Flanagan" wrote in message . .. 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" wrote in message ... 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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Charles Williams" wrote in message ... 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 "Bob Flanagan" wrote in message . .. 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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
refedit controls and Excel 2003 sp3
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\90401119 00063D11C8EF10054038389c\11.0.5614 76.0 kb dated 8 May 2003 C:\Windows\Installer\$patchcache$\managed\00002119 4100000000000000000F01FEC\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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
refedit controls and Excel 2003 sp3
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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Charles Williams" wrote in message ... 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\90401119 00063D11C8EF10054038389c\11.0.5614 76.0 kb dated 8 May 2003 C:\Windows\Installer\$patchcache$\managed\00002119 4100000000000000000F01FEC\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 |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
refedit controls and Excel 2003 sp3
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" wrote in message ... 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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Charles Williams" wrote in message ... 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\90401119 00063D11C8EF10054038389c\11.0.5614 76.0 kb dated 8 May 2003 C:\Windows\Installer\$patchcache$\managed\00002119 4100000000000000000F01FEC\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 |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
refedit controls and Excel 2003 sp3
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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Bob Flanagan" wrote in message . .. 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" wrote in message ... 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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Charles Williams" wrote in message ... 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\90401119 00063D11C8EF10054038389c\11.0.5614 76.0 kb dated 8 May 2003 C:\Windows\Installer\$patchcache$\managed\00002119 4100000000000000000F01FEC\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 |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
refedit controls and Excel 2003 sp3
Jon, in my case, leaving the reference causes problems <grin.
Bob "Jon Peltier" wrote in message ... 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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Bob Flanagan" wrote in message . .. 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" wrote in message ... 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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Charles Williams" wrote in message ... 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\90401119 00063D11C8EF10054038389c\11.0.5614 76.0 kb dated 8 May 2003 C:\Windows\Installer\$patchcache$\managed\00002119 4100000000000000000F01FEC\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 |
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
refedit controls and Excel 2003 sp3
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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Bob Flanagan" wrote in message . .. Jon, in my case, leaving the reference causes problems <grin. Bob "Jon Peltier" wrote in message ... 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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Bob Flanagan" wrote in message . .. 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" wrote in message ... 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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Charles Williams" wrote in message ... 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\90401119 00063D11C8EF10054038389c\11.0.5614 76.0 kb dated 8 May 2003 C:\Windows\Installer\$patchcache$\managed\00002119 4100000000000000000F01FEC\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 |
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
refedit controls and Excel 2003 sp3
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. "Jon Peltier" wrote: 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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Charles Williams" wrote in message ... 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 "Bob Flanagan" wrote in message . .. 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using controls with Excel 2003 | Excel Discussion (Misc queries) | |||
How to enumerate controls on a worksheet in Excel 2003 | Excel Programming | |||
Activex controls in Excel 2003 | Excel Worksheet Functions | |||
refedit control in 2003 and managed code add-in? | Excel Programming |