XL: Can't Use Visual Basic Procedure to Reference Project

ID: Q121269


The information in this article applies to:


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.

WORKAROUNDS

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:

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" 


MORE INFORMATION

For additional information, please see the following article(s) in the Microsoft Knowledge Base:

Q110755 : XL: Deleted Project or Library Listed Twice In References


When you open a Visual Basic module that references a project, Microsoft Excel searches for the referenced project file in the following directories:

  1. The directory that contained the project file when you first established the reference.


  2. The directory in which the file that contains the reference is located.


  3. The directory in which Microsoft Excel is installed.


  4. The directory in which Microsoft Windows is installed.


  5. The SYSTEM subdirectory of the Microsoft Windows directory.


  6. Any directory that is located in the path statement in the AUTOEXEC.BAT file.



REFERENCES

For more information about the References Command (Tools Menu), choose the Search button in Help and type:

References command (Tools Menu)

Additional query words: 1.00 5.00c


Keywords          : 
Version           : 5.00 5.00c 7.00
Platform          : WINDOWS 
Issue type        : 

Last Reviewed: July 29, 1999