Atlanta Custom Software Development 

   Search        Code/Page

User Login



Forgot the Password?
» Web Development
» Maintenance
» Data Integration/BI
» Information Management
» Regular Expr Tester
» Free Tools

Always declare objects with full library name

Total Hit ( 2262)

Rate this article:     Poor     Excellent 

 Submit Your Question/Comment about this article



If your application uses objects from external components, either third-party or your own libraries, a good rule of thumb is to include the complete servername.classname string in the Dim statement, as in:

Click here to copy the following block
Dim word As Word.Application

This syntax ensures that if you then move the code to another application, it will continue to work as before. In fact, if you omit the servername portion, as in:

Click here to copy the following block
Dim word As Application

the "word" variable might be pointing to the Application object exposed by another library, for example Excel's. This occurs when the References dialog lists more than a single library that exposes the Application object. The Visual Basic IDE solves the ambiguity by always binding the variable to the library that appears closer to the top of the list.
A partial solution to the problem is therefore rearranging library names in the list, so that the one you're interested in comes first, but this isn't always possible. A much better, and definitive solution, is to always use the complete syntax in all object variable declarations, as explained above.

Submitted By : Nayan Patel  (Member Since : 5/26/2004 12:23:06 PM)

Job Description : He is the moderator of this site and currently working as an independent consultant. He works with, SQL Server and other MS technologies. He is, MCDBA and MCSE. In his free time he likes to watch funny movies and doing oil painting.
View all (893) submissions by this author  (Birth Date : 7/14/1981 )

Home   |  Comment   |  Contact Us   |  Privacy Policy   |  Terms & Conditions   |  BlogsZappySys

© 2008 BinaryWorld LLC. All rights reserved.