Cyberdude
12-19-2006, 04:32 PM
I am really in a panic. All of a sudden I get the following message when I open most of my workbooks:
?Compiler error
Can?t find project or library?
Here?s the list of items that are checked in my References list:
Visual Basic for Applications
Microsoft Excel 11.0 Object Library
Microsoft Office 11.0 Object Library
atpvbaen.xls
Microsoft Visual Basic for Applications Extensibility 5.3
OLE Automation
The item that triggers the error most of the time is function CHR that is being used in a macro in my Personal.xls workbook. I can?t remember the items in the References list that used to be there, but it seems to me that I always had VBAProject, which is the name for Personal.xls. I don?t see it anywhere now. I tried adding it manually, but got the message that it was a duplicate, but I can?t find a VBAProject anywhere in the list.
Can anyone offer a solution? :help
?Compiler error
Can?t find project or library?
Here?s the list of items that are checked in my References list:
Visual Basic for Applications
Microsoft Excel 11.0 Object Library
Microsoft Office 11.0 Object Library
atpvbaen.xls
Microsoft Visual Basic for Applications Extensibility 5.3
OLE Automation
The item that triggers the error most of the time is function CHR that is being used in a macro in my Personal.xls workbook. I can?t remember the items in the References list that used to be there, but it seems to me that I always had VBAProject, which is the name for Personal.xls. I don?t see it anywhere now. I tried adding it manually, but got the message that it was a duplicate, but I can?t find a VBAProject anywhere in the list.
Can anyone offer a solution? :help