Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Missing library??? | New Users to Excel | |||
missing object library | Excel Discussion (Misc queries) | |||
Object library missing | Excel Discussion (Misc queries) | |||
Missing Library | Excel Worksheet Functions | |||
Library missing.. | Excel Programming |