Adding libraries to Access XP Object Browser

[putz]

I'm trying to use some Excel objects in Access XP. My VB/VBA books tell me I can use the following declaration to dimension a Excel Object:

Dim xapp As Excel.Application

When I do, I get:
Compile Error: User-defined type not defined

When I go to the object browser, I cannot find the Excel Library. I'm pretty sure that since I can't see the Excel Object Lib, then I would get this error. Problem is, I am new to VBA (used to 'C' alot many years ago) and do not know how to instruct VBA in Access to include the Excel Object Lib

Any help is greatly appreciated.

Thanks

 

[JeremyNYC]

Open up some code or the immediate window and hit Tools|References. There's a huge list of libraries you can add. Find the right Excel library and click there.

Also, you can use an access database (or a lot of other things) as a library, by using the browse button.

Once you do that, you'll be all set to use the objects etc. from the library, and it will be present in the Object Browser.

Hope this is helpful.

Jeremy =============
Jeremy Wallace
AlphaBet City Dataworks

http://www.AlphaBetCityDataworks.com

Take a look at the Developers' section of the site for some helpful fundamentals.

 

[putz]

Thanks a million! It worked like a charm - well, it did after I took it out of debug mode