Well, of course it might be a source of permanent bugs, but here like i
told MS Office 03 had been newly reinstalled and updates are regularly
off, as for Windows too. Office 11 is the right Volume, but I don't know
the names of DLL Files for essential DLL linkages which are listed
below.
-----Ursprüngliche Nachricht-----
Von: Joel [mailto:
[email protected]]
Bereitgestellt: Montag, 3. November 2008 12:49
Bereitgestellt in: microsoft.public.excel.programming
Unterhaltung: problem with DLL Library
Betreff: Re: problem with DLL Library
the microsoft office DLL are under
c:\Program files\Microsoft Office
Depending on the version of office it could be under Office9, Office10,
Office11, Office12.
The normal microsoft patches may of created the problem. Do you have
automatic upgrades set on your PC. Microsoft preferes people configure
their
PC to have automatic upgrades so vital security patches get installed
which
minimizes Microsoft being blamed when Virsus are spread because of holes
in
their software.
The problem when automatic updtes are installed you don't realize when
upgrades are performed and create other problems like what you are
seeing. I
keep automatic updates turned off , but manually perform the upgrades
about
once a month. If I know a serious virus is going around I will do the
updates sooner. This way when a problem occurs on my PC I know that the
updates is a likely cause of the problem.
Leon Galushko said:
Hi,
i use Microsoft Office 2003 and therefore have Microsoft Excel 11.1
Object Library, which had been on its place before and after this
problem had occurred. The occurrence of this really worrying problem had
nothing with upgrading in common because there wasn't MS Office
upgrading, so volume OFFICE 11 is in any way correct; besides trying to
solve it I had been reinstalled MS Office and Windows 2000 (my operating
system):
Now, once more, what standard DLL's have above all to be, are:
(*)Visual Basic for Applications
(*)Visual Basic objects and procedures
(*)Visuale Basic runtime objects and procedures
What gives me some doubts on its approprietness, is the path on
(*) Visual Basic objects and procedures:
Wich is: D:\VB98\VB6.OLB
It's looks like retrieving it from my Visual Basic 6 VOLUME, which is
installed too (on drive D) and has clearly the same DLL.
It's maybe some confusion between DLL for VBA and DLL for VB, but I'm
not sure.
Could anybody give me the hint on his own path or I meen to tell the
name of this file for DLL Visual Basic objects and procedures?
Or could somebody know the clue about solving this nuisance (mean,
reinstate those important VBA DLL's)?
Cheers,
Leon
During upgrading windows and Microsoft Office, sometimes the Office
directory
moves to Office10, Office11, or office12 (under c:\Project
Files\Microsoft
Office). I seen cases where this process was not done properly.
The solution is simple. Go to VBA menu Tools - Reference and select
Microsoft Excel XX.X Object Library. Then go to Browse and find the
library.
Select the name and then press OK.
for some reason the name is selected properly but Excel doesn't
recognize
the selection. Many people have the problem with the REF Edit object on
userforms.
Office program name Type library name
File name
Microsoft Access 2002 Microsoft Access 10.0 Object Library
