XL97: Reference Incorrectly Listed as "MISSING" in MS Excel 97

MORE INFORMATION

When you create a workbook that uses Visual Basic for Applications macros in Microsoft Excel, you can create references to other files, such as workbooks, add-ins, XLL files, dynamic-link library files (DLLs), or object libraries (OLBs). To create a reference in Microsoft Excel 97, follow these steps:

1. On the Tools menu, point to Macro, and click Visual Basic Editor. Or, press ALT+F11.
2. In the Visual Basic Editor, click References on the Tools menu.
3. If the file to which you want to create a reference is already in the list, click to select the check box next to the reference.
   
   Otherwise, click Browse. Use the Add Reference dialog box to select the file to which you want to create a reference, and then click Open.
4. Click OK.

When you create a reference to another file, the path to that file is stored in the workbook.

When you open the workbook, Microsoft Excel may search for referenced files in the locations that are listed in the following table.

    Location   Description
   ----------------------------------------------------------------------

   1          The folder in which the file existed when you created the
              reference

   2          The folder in which the referencing file (the workbook you
              are opening) currently exists

   3          The folder in which the Microsoft Excel progrm, Excel.exe,
              currently exists

   4          The Windows folder (for example, C:\Windows)

   5          The Windows\System folder (for example, C:\Windows\System)

   6          Any folders listed in the PATH statement in your
              C:\Autoexec.bat file

   7          Any folders listed in the following key in the registry:

                 HKEY_CURRENT_USER\Software\Microsoft\Office\8.0\Excel\ 

                    Microsoft Excel\AddIn Path

              NOTE: This key is present only if you install Microsoft
              Excel 97.
				

Different versions of Microsoft Excel search for referenced files in different locations. The locations that the different versions search are listed in the following table.

 Version                    1*    2     3     4     5     6     7
   -----------------------------------------------------------------

   Microsoft Excel 5.x       yes   yes   yes   yes   yes   yes

   Microsoft Excel 7.0       yes   yes   yes   yes   yes   yes

   Microsoft Excel 97        yes   yes

   Microsoft Excel 97 SR-1   yes   yes   yes   yes   yes   yes   yes
				

*The numbers represent folders that are described in the previous table.