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)

"Ko Vijn" wrote in message
...
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