Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB error
Hi
While running an Access macro I am getting a VB error stating "Compile Error" Can't find project or library. When I click O.K it takes you to a reference page which shows MISSING: Microsoft Excel 11.0 Object Library. The macro is creating an excel document it needs this library to create the excel object. Does anyone know why? Ajay |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB error
To create an instance of Excel and run VB code you will need the Object
Library loaded. -- Cheers Nigel "ajmister" wrote in message ... Hi While running an Access macro I am getting a VB error stating "Compile Error" Can't find project or library. When I click O.K it takes you to a reference page which shows MISSING: Microsoft Excel 11.0 Object Library. The macro is creating an excel document it needs this library to create the excel object. Does anyone know why? Ajay |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB error
This probably means that the code was written on a higher version of Excel
than the one that you are running on. The new machine will not have Excel 11.0 Object Library, but I bet it has a lower version. If you scroll down and find that lower version, check it, and uncheck the 11.0 version, it should work. Moral. Develop on the lowest Excel deployment version. -- HTH RP (remove nothere from the email address if mailing direct) "ajmister" wrote in message ... Hi While running an Access macro I am getting a VB error stating "Compile Error" Can't find project or library. When I click O.K it takes you to a reference page which shows MISSING: Microsoft Excel 11.0 Object Library. The macro is creating an excel document it needs this library to create the excel object. Does anyone know why? Ajay |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
run-time error '1004': Application-defined or object-deifined error | Excel Programming | |||
Automation Error, Unknown Error. Error value - 440 | Excel Programming |