May 25, 2005 - My VB program will not compile because there is no reference to the “Microsoft DTS Package Object Library” – I think. I.e.: Dim objPackage As. May 07, 2007  MISSING:Microsoft DTSPackage Objects Library alomg with all the other references selected!!! Actually Microsoft DTS package Comes with SQL Server Database or Desk top Engine. Browse more Visual Basic 4 / 5 / 6 Questions on Bytes. Question stats. Viewed: 5811; replies: 1. Jan 23, 2004 - In this series, Brian Knight will show you how to use the DTS object model to ex. About half-way down, check the Microsoft DTSPackage Object Library item. Here's the complete example: (you can also download it here).

• Microsoft Excel Object Library

The Visual Basic for Applications object library is no longer a standalone file; it is integrated into the dynamic-link library (DLL).Under unusual circumstances a previous version of the object library (vaxxx.olb or vaxxxx.olb) corresponding to the language of the project might be needed, but not found. This error has the following causes and solutions:

• The object library is missing completely, isn't in the expected directory, or is an incorrect version. Search your disk to make sure the object library is in the correct directory, as specified in the host-application documentation.

If the missing library is a language version that is installed by the host application, it may be easiest to simply rerun the setup program. If a project requires a different language object library than the one that accompanies your host application (for example, if someone sends you a project written on a machine set up for a different language), make sure the correct language version of the Visual Basic object library is included with the project and it is installed in the expected location.Applications may support different language versions of their object libraries. To find out which language version is required, display the References dialog box, and see which language is indicated at the bottom of the dialog box.Object libraries exist in different versions for each platform. Therefore, when projects are moved across platforms, for example, from Macintosh to Microsoft Windows, the correct language version of the referenced library for that platform must be available in the location specified in your host application documentation. Note that some language codes are two characters while others are three characters.The Visual Basic object library file name is constructed as follows:

• Windows: Application Code + Language Code + [Version].OLB. For example: The French Visual Basic for Applications object library for version 2 was vafr2.olb.

• Macintosh: Application Name Language Code [Version] OLB. For example: The French Visual Basic for Applications object library for version 2 was VA FR 2 OLB.

If you can't find a missing project or object library on your system, contact the referencing project's author. If the missing library is a Microsoft application object library, you can obtain it as follows:

• If you have access to Microsoft electronic technical support services, refer to the technical support section of this Help file. Under electronic services, you will find instructions on how to use the appropriate service option.

• If you don't have access to Microsoft electronic technical support services, Microsoft object libraries are available upon request as an application note from Microsoft. Information on how to contact your local Microsoft product support organization is also available in the technical support section of this Help file.

For additional information, select the item in question and press F1 (in Windows) or HELP (on the Macintosh).

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.

So I'm having to run someone else's excel app on my PC, and I'm getting 'Can't find Project or Library' on standard functions such as date, format, hex, mid, etc.

Some research indicates that if I prefix these functions with 'VBA.' as in 'VBA.Date' then it'll work fine. Download minecraft mod installer.

Webpages suggest it has to do with my project references on my system, whereas they must be ok on the developer's system. I'm going to be dealing with this for some time from others, and will be distributing these applications to many others, so I need to understand what's wrong with my excel setup that I need to fix, or what needs to be changed in the xls file so that it'll run on a variety of systems. I'd like to avoid making everyone use 'VBA.' as an explicit reference, but if there's no ideal solution I suppose that's what we'll have to do.

• How do I make 'VBA.' implicit in my project properties/references/etc?

-Adam

5 Answers

I have seen errors on standard functions if there was a reference to a totally different library missing.

In the VBA editor launch the Compile command from the menu and then check the References dialog to see if there is anything missing and if so try to add these libraries.

In general it seems to be good practice to compile the complete VBA code and then saving the document before distribution.

I had the same problem. This worked for me:

• In VB go to Tools » References
• Uncheck the library 'Crystal Analysis Common Controls 1.0'. Or any library.
• Just leave these 5 references:
  1. Visual Basic For Applications (This is the library that defines the VBA language.)
  2. Microsoft Excel Object Library (This defines all of the elements of Excel.)
  3. OLE Automation (This specifies the types for linking and embedding documents and for automation of other applications and the 'plumbing' of the COM system that Excel uses to communicate with the outside world.)
  4. Microsoft Office (This defines things that are common to all Office programs such as Command Bars and Command Bar controls.)
  5. Microsoft Forms 2.0 This is required if you are using a User Form. This library defines things like the user form and the controls that you can place on a form.
• Then Save.

I have experienced this exact problem and found, on the users machine, one of the libraries I depended on was marked as 'MISSING' in the references dialog. In that case it was some office font library that was available in my version of Office 2007, but not on the client desktop.

The error you get is a complete red herring (as pointed out by divo). Bomb factory pultec bundle cracked.

Fortunately I wasn't using anything from the library, so I was able to remove it from the XLA references entirely. I guess, an extension of divo' suggested best practice would be for testing to check the XLA on all the target Office versions (not a bad idea in any case).

In my case, it was that the function was AMBIGUOUS as it was defined in the VBA library (present in my references), and also in the Microsoft Office Object Library (also present). I removed the Microsoft Office Object Library, and voila! Money mark meets the mattson 2 band. No need to use the VBA. prefix.

In my case I was checking work done on my office computer (with Visio installed) at home (no Visio). Even though VBA appeared to be getting hung up on simple default functions, the problem was that I had references to the Visio libraries still active.

protected by Tim Post♦Jul 12 '11 at 2:48

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?

Microsoft Excel Object Library

Not the answer you're looking for? Browse other questions tagged excel-vbavbareferencenamespacesexcel or ask your own question.