Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Wierd Problem Excel 97
This problem defies logic and I am really scratching my head over it!
I would appreciate some help. I have four computers A, B, C, D, all running Excel 97 SP2. Three are XP SP3 and one is W2000 SP4 I have a financial worksheet which utilises VB code in workbook and a number of VB forms. Works faultlessly on two of the XP computers (A & B) and I can interchange files between these two computers without a problem. But on two other computers (C & D) , it fails with the message "Compile error - can't find project or library" So, I rebuild the workbook on either C or D by doing the following: - Open a new workbook - Copy all the data in all the Sheets from the failing workbook to the new - copy the Workbook and sheet VB code from the failing workbook to the new - Export all the VB forms from the failing workbook - Import all the VB forms to the new workbook Note - there is no change to any of the code. Now the new workbook works on any of the computers, and I can use it, save it, reuse it without a problem on the computer that I rebuilt it on. However if I open it on computer A or B, change a data value then save it, that saved file continues to work OK on A & B but gets the compile error on computers C & D. Any suggestions would be welcome! John Allen |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Wierd Problem Excel 97
haven't used 97 in ages so this may be wrong. but in vb, click tools and then
references and see if any are tagged as missing. someone more familiar with 97 may chime in. -- Gary "John A" wrote in message ... This problem defies logic and I am really scratching my head over it! I would appreciate some help. I have four computers A, B, C, D, all running Excel 97 SP2. Three are XP SP3 and one is W2000 SP4 I have a financial worksheet which utilises VB code in workbook and a number of VB forms. Works faultlessly on two of the XP computers (A & B) and I can interchange files between these two computers without a problem. But on two other computers (C & D) , it fails with the message "Compile error - can't find project or library" So, I rebuild the workbook on either C or D by doing the following: - Open a new workbook - Copy all the data in all the Sheets from the failing workbook to the new - copy the Workbook and sheet VB code from the failing workbook to the new - Export all the VB forms from the failing workbook - Import all the VB forms to the new workbook Note - there is no change to any of the code. Now the new workbook works on any of the computers, and I can use it, save it, reuse it without a problem on the computer that I rebuilt it on. However if I open it on computer A or B, change a data value then save it, that saved file continues to work OK on A & B but gets the compile error on computers C & D. Any suggestions would be welcome! John Allen |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Wierd Problem Excel 97
Hello John,
I agree with Gary. Some components that your worksheet VBA replies on are possibly missing in the computer C and D. The KB article http://support.microsoft.com/kb/282331 gives an example that, when MDAC version is incorrect, the compiler error: Can't Find Project or Library is thrown. Please also note that Microsoft stopped the support of Excel 97 in 1/16/2004. You can view Microsoft Support Lifecycle site for more information: http://support.microsoft.com/lifecyc...=1757&x=9&y=13. Regards, Jialiang Ge , remove 'online.') Microsoft Online Community Support ================================================= Delighting our customers is our #1 priority. We welcome your comments and suggestions about how we can improve the support we provide to you. Please feel free to let my manager know what you think of the level of service provided. You can send feedback directly to my manager at: . This posting is provided "AS IS" with no warranties, and confers no rights. ================================================= |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Wierd Problem Excel 97
You may well have a problem with .EXD files, which are created by MSoft
Forms. There have been some incompatibilities introduced by Microsoft updates, which have been applied on some computers and not on others. Try to delete all the .EXD files, as they will automatically be recreated as needed. 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 Charles __________________________________________________ The Excel Calculation Site http://www.decisionmodels.com "Jialiang Ge [MSFT]" wrote in message ... Hello John, I agree with Gary. Some components that your worksheet VBA replies on are possibly missing in the computer C and D. The KB article http://support.microsoft.com/kb/282331 gives an example that, when MDAC version is incorrect, the compiler error: Can't Find Project or Library is thrown. Please also note that Microsoft stopped the support of Excel 97 in 1/16/2004. You can view Microsoft Support Lifecycle site for more information: http://support.microsoft.com/lifecyc...=1757&x=9&y=13. Regards, Jialiang Ge , remove 'online.') Microsoft Online Community Support ================================================= Delighting our customers is our #1 priority. We welcome your comments and suggestions about how we can improve the support we provide to you. Please feel free to let my manager know what you think of the level of service provided. You can send feedback directly to my manager at: . This posting is provided "AS IS" with no warranties, and confers no rights. ================================================= |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Wierd Problem Excel 97
Thanks Gary
Yes Missing is Ref Edit Control. I see that on computers C & D it is looking for Ref Edit Control in c:\program files\microsoft office\office12, which doesn't exist, but does exist on computers A & B because Publisher 2007 is installed on those. Refedit.twd and refedit.dll are in the system32 folder on systems C & D. How would I fix that? John On Wed, 28 May 2008 02:48:50 -0400, "Gary Keramidas" <GKeramidasATmsn.com wrote: haven't used 97 in ages so this may be wrong. but in vb, click tools and then references and see if any are tagged as missing. someone more familiar with 97 may chime in. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Wierd Problem Excel 97
Thanks Charles
I found one of those in temp\vba, deleted it but still got the same problem. in ....\microsoft\forms the only file in there is excel.box John On Wed, 28 May 2008 10:52:03 +0100, "Charles Williams" wrote: You may well have a problem with .EXD files, which are created by MSoft Forms. There have been some incompatibilities introduced by Microsoft updates, which have been applied on some computers and not on others. Try to delete all the .EXD files, as they will automatically be recreated as needed. 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 Charles _________________________________________________ _ The Excel Calculation Site http://www.decisionmodels.com "Jialiang Ge [MSFT]" wrote in message . .. Hello John, I agree with Gary. Some components that your worksheet VBA replies on are possibly missing in the computer C and D. The KB article http://support.microsoft.com/kb/282331 gives an example that, when MDAC version is incorrect, the compiler error: Can't Find Project or Library is thrown. Please also note that Microsoft stopped the support of Excel 97 in 1/16/2004. You can view Microsoft Support Lifecycle site for more information: http://support.microsoft.com/lifecyc...=1757&x=9&y=13. Regards, Jialiang Ge , remove 'online.') Microsoft Online Community Support ================================================= Delighting our customers is our #1 priority. We welcome your comments and suggestions about how we can improve the support we provide to you. Please feel free to let my manager know what you think of the level of service provided. You can send feedback directly to my manager at: . This posting is provided "AS IS" with no warranties, and confers no rights. ================================================= |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Wierd Problem Excel 97
Uncheck the reference and save the file. (Isn't always sufficient to fix the
problem.) - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "John A" wrote in message ... Thanks Gary Yes Missing is Ref Edit Control. I see that on computers C & D it is looking for Ref Edit Control in c:\program files\microsoft office\office12, which doesn't exist, but does exist on computers A & B because Publisher 2007 is installed on those. Refedit.twd and refedit.dll are in the system32 folder on systems C & D. How would I fix that? John On Wed, 28 May 2008 02:48:50 -0400, "Gary Keramidas" <GKeramidasATmsn.com wrote: haven't used 97 in ages so this may be wrong. but in vb, click tools and then references and see if any are tagged as missing. someone more familiar with 97 may chime in. |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Wierd Problem Excel 97
If I try to uncheck it, it says "Can't remove control or reference; in
use" On Wed, 28 May 2008 08:17:24 -0400, "Jon Peltier" wrote: Uncheck the reference and save the file. (Isn't always sufficient to fix the problem.) - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "John A" wrote in message .. . Thanks Gary Yes Missing is Ref Edit Control. I see that on computers C & D it is looking for Ref Edit Control in c:\program files\microsoft office\office12, which doesn't exist, but does exist on computers A & B because Publisher 2007 is installed on those. Refedit.twd and refedit.dll are in the system32 folder on systems C & D. How would I fix that? John On Wed, 28 May 2008 02:48:50 -0400, "Gary Keramidas" <GKeramidasATmsn.com wrote: haven't used 97 in ages so this may be wrong. but in vb, click tools and then references and see if any are tagged as missing. someone more familiar with 97 may chime in. |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Wierd Problem Excel 97
Hmm, Excel 2000 through 2007 let you uncheck the RefEdit reference. You get
the problem even if it says "Missing:"? Let's try something equally desperate. How about browsing to the "real" RefEdit on the computer in question, and checking its box. I'm hoping that this will let you remove the broken reference. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "John A" wrote in message ... If I try to uncheck it, it says "Can't remove control or reference; in use" On Wed, 28 May 2008 08:17:24 -0400, "Jon Peltier" wrote: Uncheck the reference and save the file. (Isn't always sufficient to fix the problem.) - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "John A" wrote in message . .. Thanks Gary Yes Missing is Ref Edit Control. I see that on computers C & D it is looking for Ref Edit Control in c:\program files\microsoft office\office12, which doesn't exist, but does exist on computers A & B because Publisher 2007 is installed on those. Refedit.twd and refedit.dll are in the system32 folder on systems C & D. How would I fix that? John On Wed, 28 May 2008 02:48:50 -0400, "Gary Keramidas" <GKeramidasATmsn.com wrote: haven't used 97 in ages so this may be wrong. but in vb, click tools and then references and see if any are tagged as missing. someone more familiar with 97 may chime in. |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
Wierd Problem Excel 97
Jon
I tried that and it let me add the "real" refedit control but when I clicked OK it said "Name conflicts with existing module, project or object library" and I still can't untick the offending one. John On Wed, 28 May 2008 21:07:51 -0400, "Jon Peltier" wrote: Hmm, Excel 2000 through 2007 let you uncheck the RefEdit reference. You get the problem even if it says "Missing:"? Let's try something equally desperate. How about browsing to the "real" RefEdit on the computer in question, and checking its box. I'm hoping that this will let you remove the broken reference. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "John A" wrote in message .. . If I try to uncheck it, it says "Can't remove control or reference; in use" On Wed, 28 May 2008 08:17:24 -0400, "Jon Peltier" wrote: Uncheck the reference and save the file. (Isn't always sufficient to fix the problem.) - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "John A" wrote in message ... Thanks Gary Yes Missing is Ref Edit Control. I see that on computers C & D it is looking for Ref Edit Control in c:\program files\microsoft office\office12, which doesn't exist, but does exist on computers A & B because Publisher 2007 is installed on those. Refedit.twd and refedit.dll are in the system32 folder on systems C & D. How would I fix that? John On Wed, 28 May 2008 02:48:50 -0400, "Gary Keramidas" <GKeramidasATmsn.com wrote: haven't used 97 in ages so this may be wrong. but in vb, click tools and then references and see if any are tagged as missing. someone more familiar with 97 may chime in. |
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
Wierd Problem Excel 97
I have resolved this problem by upgrading to Office 2007. All files
that previously had problems work fine in 2007 Thanks for your help. John On Wed, 28 May 2008 16:18:12 +1000, John A wrote: This problem defies logic and I am really scratching my head over it! I would appreciate some help. I have four computers A, B, C, D, all running Excel 97 SP2. Three are XP SP3 and one is W2000 SP4 I have a financial worksheet which utilises VB code in workbook and a number of VB forms. Works faultlessly on two of the XP computers (A & B) and I can interchange files between these two computers without a problem. But on two other computers (C & D) , it fails with the message "Compile error - can't find project or library" So, I rebuild the workbook on either C or D by doing the following: - Open a new workbook - Copy all the data in all the Sheets from the failing workbook to the new - copy the Workbook and sheet VB code from the failing workbook to the new - Export all the VB forms from the failing workbook - Import all the VB forms to the new workbook Note - there is no change to any of the code. Now the new workbook works on any of the computers, and I can use it, save it, reuse it without a problem on the computer that I rebuilt it on. However if I open it on computer A or B, change a data value then save it, that saved file continues to work OK on A & B but gets the compile error on computers C & D. Any suggestions would be welcome! John Allen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotals problem - wierd! | Excel Programming | |||
Very wierd problem. Please help | Excel Programming | |||
Wierd Save problem | Excel Discussion (Misc queries) | |||
WIERD Excel Problem | Setting up and Configuration of Excel | |||
Wierd variable values problem | Excel Programming |