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

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

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.
=================================================

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.
=================================================

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.

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.
=================================================

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.

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.

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.

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.

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