Missing reference in Excell
Posted on 2001-07-12
I'm honored to ask the first ever real question here at EE...
OS & MS Office
MS Office 97 (no SP which I know of)
Windows 2000 SP-2
VisualBasic For Applications
Microsoft Excell 8.0 Object Library
Microsoft Forms 2.0
Microsoft Office 8.0 Object Library
The question has two parts, which I think are connected(?).
1. When I open the problematic Excell file, the application notifs that there is a linked file (which I'm sure there is NOT), and asks me if I want to open it as well. If I reply with YES, a browse window opens (to locate the file) and it says:
File Name: E-mail
File Type: WorkSheet
No such file exists on my computer.
How can I find the reference to this file name in my work book in order to remove it?
2. If I insert an ActiveX component (such as ListBox), and paste in some code (e.g. ListBox1.Left = 100), I'm getting a compile error of Missing Reference.
---------- Added on 7/19/2001 -------------
If there are no ActiveX controls present in the spreadsheet, then I get no MISSING reference.
---------- End of addition ----------------
When I open the references (tools->references) and point to the MISSING reference, the info that I get at the bottom of the window is as follows:
Location: c:\Documents and Settings\<LoginUserName>\Local Settings\Temp
(Where <LoginUserName> is the name of the user logged to Win2K.
No such directory exists on the computer...
How do I find which file I should refere to, in order to solve the problem?
When I run this file under Windows 95, the problem occures as well.
Any suggestions / solutions will be mostly appritiated.
Thanx in advance