"Steve" schreef in bericht
...

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

-----Original 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


.