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

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

"Bob Phillips" schreef in bericht
...
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




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

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


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


.

"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


.