Hi Edwin, this is taken verbatim from the help file in Excel:
"If you use the objects in other applications as part of your Visual
Basic application, you may want to establish a reference to the object
libraries of those applications. Before you can do that, you must first
be sure that the application provides an object library.
To see if an application provides an object library
From the Tools menu, choose References to display the References dialog
box.
The References dialog box shows all object libraries registered with
the operating system. Scroll through the list for the application whose
object library you want to reference. If the application isn't listed,
you can use the Browse button to search for object libraries (*.olb and
*.tlb) or executable files (*.exe and *.dll on Windows). References
whose check boxes are checked are used by your project; those that
aren't checked are not used, but can be added."
The references I have checked are:
Visual Basic for Applications
Microsoft Excel 10.0 Object Library
OLE Automation
Microsoft Office 10.0 Object Library
Microsoft Outlook 10.0 Object Library
Microsoft Forms 2.0 Object Library
Microsoft Scripting Runtime
Microsoft Visual Basic for Applications Extensibility 5.3
Depending on your Excel version, the versions might be slightly
different, for instance:
Microsoft Excel 10.0 Object Library - might be:
Microsoft Excel 9.0 Object Library ....etc
Hope this helps some and hope I didn't confuse the issue...
Good luck,
Dave M.
P.S. Of course you can only establish references from your Visual Basic
window, not the normal Excel window....