Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Library missing..
Hello!
When I open my file (containing VBA coding), a message box appears and tell me that a library is missing and inside the code, the word "Chr" is selected.. I looked and found that this function belongs library "VBA" stored in the file "C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBAE6.DLL" So how come that Excel cannot find this function if the library "Visual Basic for Applications" is cheeked in the Reference dialog box? Thanks for any suggestion! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Library missing..
Generally, this error is misleading. When you get the message, go into
tools=References in the VBE and see if there is a file shown as MISSING. This is usually the actual file that is really missing. You need to resolve this file - either find it or remove it as a reference. -- Regards, Tom Ogilvy "Warrio" wrote in message ... Hello! When I open my file (containing VBA coding), a message box appears and tell me that a library is missing and inside the code, the word "Chr" is selected.. I looked and found that this function belongs library "VBA" stored in the file "C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBAE6.DLL" So how come that Excel cannot find this function if the library "Visual Basic for Applications" is cheeked in the Reference dialog box? Thanks for any suggestion! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Library missing..
"Tom Ogilvy" wrote in message ...
Generally, this error is misleading. When you get the message, go into tools=References in the VBE and see if there is a file shown as MISSING. This is usually the actual file that is really missing. You need to resolve this file - either find it or remove it as a reference. Tom, This was incredibly helpful advice. I was having a similar problem, getting a message about VBAE6.dll, and would not have had a clue to look in the Tools | References menu if you had not posted. Thanks a lot. Elvi Dalgaard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Missing library??? | New Users to Excel | |||
missing object library | Excel Discussion (Misc queries) | |||
Object library missing | Excel Discussion (Misc queries) | |||
Missing library when running 98 project on 2003 | Excel Discussion (Misc queries) | |||
Missing Library | Excel Worksheet Functions |