Hi,



after some extensions to my VBA Excel PROJECTS OPTIONS by some extra

the essential option



Visual Basic runtime objects and procedures



has been missing;



Visual Basic objects and procedures is still there, but it puts my vba -
macro out of work.

I made some internet search and assumed that is about some DLL -
Libraries links, which is now failing.

I gone so far as to reinstall my Windows and Microsoft Office, but it
didn't help.

Any ideas how it can be reinstated?

Thanks

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
MSACC.OLB
Microsoft Excel 2002 Microsoft Excel 10.0 Object Library
EXCEL.EXE
Microsoft FrontPage® 2002
Microsoft FrontPage 5.0 Web Object
Reference Library

FRONTPG.EXE
Microsoft Office XP Microsoft Office 10.0 Object Library
MSO.DLL
Microsoft Outlook® 2002 Microsoft Outlook 10.0 Object Library
MSOUTL.OLB
Microsoft PowerPoint® 2002
Microsoft PowerPoint 10.0 Object
Library MSPPT.OLB
Microsoft Word 2002 Microsoft Word 10.0 Object Library
MSWORD.OLB


"Leon Galushko" wrote:

Hi,



after some extensions to my VBA Excel PROJECTS OPTIONS by some extra

the essential option



Visual Basic runtime objects and procedures



has been missing;



Visual Basic objects and procedures is still there, but it puts my vba -
macro out of work.

I made some internet search and assumed that is about some DLL -
Libraries links, which is now failing.

I gone so far as to reinstall my Windows and Microsoft Office, but it
didn't help.

Any ideas how it can be reinstated?

Thanks

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, a
(*)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
MSACC.OLB
Microsoft Excel 2002 Microsoft Excel 10.0 Object Library

EXCEL.EXE
Microsoft FrontPageR 2002
Microsoft FrontPage 5.0 Web Object
Reference Library


FRONTPG.EXE
Microsoft Office XP Microsoft Office 10.0 Object Library

MSO.DLL
Microsoft OutlookR 2002 Microsoft Outlook 10.0 Object Library
MSOUTL.OLB
Microsoft PowerPointR 2002
Microsoft PowerPoint 10.0 Object
Library MSPPT.OLB
Microsoft Word 2002 Microsoft Word 10.0 Object Library
MSWORD.OLB


"Leon Galushko" wrote:

Hi,



after some extensions to my VBA Excel PROJECTS OPTIONS by some extra

the essential option



Visual Basic runtime objects and procedures



has been missing;



Visual Basic objects and procedures is still there, but it puts my vba
-
macro out of work.

I made some internet search and assumed that is about some DLL -
Libraries links, which is now failing.

I gone so far as to reinstall my Windows and Microsoft Office, but it
didn't help.

Any ideas how it can be reinstated?

Thanks

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" wrote:


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, a
(*)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
MSACC.OLB
Microsoft Excel 2002 Microsoft Excel 10.0 Object Library

EXCEL.EXE
Microsoft FrontPageR 2002
Microsoft FrontPage 5.0 Web Object
Reference Library


FRONTPG.EXE
Microsoft Office XP Microsoft Office 10.0 Object Library

MSO.DLL
Microsoft OutlookR 2002 Microsoft Outlook 10.0 Object Library
MSOUTL.OLB
Microsoft PowerPointR 2002
Microsoft PowerPoint 10.0 Object
Library MSPPT.OLB
Microsoft Word 2002 Microsoft Word 10.0 Object Library
MSWORD.OLB


"Leon Galushko" wrote:

Hi,



after some extensions to my VBA Excel PROJECTS OPTIONS by some extra

the essential option



Visual Basic runtime objects and procedures



has been missing;



Visual Basic objects and procedures is still there, but it puts my vba
-
macro out of work.

I made some internet search and assumed that is about some DLL -
Libraries links, which is now failing.

I gone so far as to reinstall my Windows and Microsoft Office, but it
didn't help.

Any ideas how it can be reinstated?

Thanks

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 ]
Bereitgestellt: Montag, 3. November 2008 12:49
Bereitgestellt in: microsoft.public.excel.programming
Unterhaltung: problem with DLL Library
Betreff: 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" wrote:


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, a
(*)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

MSACC.OLB
Microsoft Excel 2002 Microsoft Excel 10.0 Object Library

EXCEL.EXE
Microsoft FrontPageR 2002
Microsoft FrontPage 5.0 Web
Object
Reference Library


FRONTPG.EXE
Microsoft Office XP Microsoft Office 10.0 Object Library

MSO.DLL
Microsoft OutlookR 2002 Microsoft Outlook 10.0 Object Library
MSOUTL.OLB
Microsoft PowerPointR 2002
Microsoft PowerPoint 10.0 Object
Library MSPPT.OLB
Microsoft Word 2002 Microsoft Word 10.0 Object Library

MSWORD.OLB


"Leon Galushko" wrote:

Hi,



after some extensions to my VBA Excel PROJECTS OPTIONS by some extra


the essential option



Visual Basic runtime objects and procedures



has been missing;



Visual Basic objects and procedures is still there, but it puts my
vba
-
macro out of work.

I made some internet search and assumed that is about some DLL -
Libraries links, which is now failing.

I gone so far as to reinstall my Windows and Microsoft Office, but
it
didn't help.

Any ideas how it can be reinstated?

Thanks