Thread: VB error
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nigel Nigel is offline
external usenet poster
 
Posts: 923
Default 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