XL: Can't Use Visual Basic Procedure to Reference Project (121269)
The information in this article applies to:
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 5.0c
- Microsoft Excel for Windows NT 5.0
This article was previously published under Q121269 SYMPTOMS
In Microsoft Excel, you cannot use a Visual Basic procedure to establish a
reference to a project or to an object library. For example, if you turn on
the Macro Recorder, and you use the References dialog box in a Visual Basic
module to establish a reference to a project or an object library, nothing
is recorded.
NOTE: A project is any file that contains a Visual Basic for Applications
module, such as an .XLS or .XLA file.
WORKAROUND
To establish a reference in a Visual Basic module to a project, when you
will be copying the module to another computer, do either of the following:
- In the module that you want to copy to a different computer, use the
References dialog box (Tools menu) to reference the project before you
copy the module to a different computer. Then copy the workbook that
contains this module, and the referenced project to the same directory
on the second computer. When you use this method, Microsoft Excel finds
the referenced project and establishes the reference again when you run
the procedure.
You can also copy the referenced project to the Microsoft Excel
directory, the Microsoft Windows directory, the Microsoft Windows SYSTEM
subdirectory, or any directory that is in the MS-DOS path statement.
-or-
- You can call a Visual Basic procedure that is located in another project
by first opening the project file, and then using the Run method of the
Application object, and specifying the name of the referenced project
and the name of the procedure as in the following example:
Microsoft provides examples of Visual Basic procedures for
illustration only, without warranty either expressed or implied,
including but not limited to the implied warranties of
merchantability and/or fitness for a particular purpose. This Visual
Basic procedure is provided 'as is' and Microsoft does not guarantee
that it can be used in all situations. Microsoft does not support
modifications of this procedure to suit customer requirements for a
particular purpose.
Workbooks.Open("BOOK1.XLS")
Application.Run "BOOK1.XLS!Macro1"
REFERENCES
For more information about the References Command (Tools Menu),
choose the Search button in Help and type:
References command (Tools Menu)
Modification Type: | Minor | Last Reviewed: | 8/15/2005 |
---|
Keywords: | KB121269 |
---|
|