Wierd Problem Excel 97

[John A]

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

 

[Gary Keramidas]

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.

 

[Jialiang Ge [MSFT]]

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/lifecycle/?LN=en-us&p1=1757&x=9&y=13.

Regards,
Jialiang Ge ([email protected], 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:
(e-mail address removed).

This posting is provided "AS IS" with no warranties, and confers no rights.
=================================================

 

[Charles Williams]

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

 

[John A]

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

 

[John A]

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

 

[Jon Peltier]

Uncheck the reference and save the file. (Isn't always sufficient to fix the
problem.)

- Jon

 

[John A]

If I try to uncheck it, it says "Can't remove control or reference; in
use"

 

[Jon Peltier]

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

 

[John A]

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

 

[John A]

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