Missing library?

[Ko Vijn]

Recently I opened on of my older Excel Workbooks with a lot of VBA code.
Book was probably made with Excel 97, and now opened with Excel 2000.
Unfortunately it would run no macro's until variables were dim'd (a good
idea anyway) but also simple VBA statements like debug.print chr$(65) would
generate a message stating 'Compile Error, Cant find Project or Library'

In VBA Editor - References I found the message 'Missing MSISys OLE Control
Module' in location 'Program Files\Common files\Microsoft Shared\MS....' The
dots could not be read since the rest was hidden in de textbox.

Other (newer and older) workbooks work fine.

How come I suddenly miss a library from a workbook which has been running
OK?

But, but more important, how could I repair the workbook?

Again, when I open Excel with a new workbook: its works fine (eg debug.print
chr$(65)). Adding a regular workbook: everything is fine, but when adding
this one particular workbook, VBA fails.

Something to do with language version? I was using dutch versions 97 and
2000.

Thanks for any hints, Ko

 

[Bob Phillips]

The workbook was probably saved with a reference to an older version to a
library.When loaded on a machine without that version, you get the Missing
message. This often causes problems in the string routines.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Steve]

In the newer version of VBA (Office 2000), you only need
to put Chr(65). Maybe try search and replace on the chr$
entries.

 

[Ko Vijn]

In the newer version of VBA (Office 2000), you only need
to put Chr(65). Maybe try search and replace on the chr$
entries.

Using chr$ or chr is not an issue: neither work. I just used them as
illustration that simpel VBA statements don't work anymore
Ko

 

[Ko Vijn]

The workbook was probably saved with a reference to an older version to a
library.When loaded on a machine without that version, you get the Missing
message. This often causes problems in the string routines.
Bob Phillips

Thanks Bob,
This hint let me uncheck the reference to OLE automation (which I did'nt
need anyway)
after which everything was fine.
Ko