Outlook CreateObject question

[salad]

I have the following code. I have a reference to the Outlook library in
the reference list. My machine is standalone, not on a network.

Dim Olapp As Outlook.Application
Set Olapp = CreateObject("Outlook.Application")

This blows up with the message "Automation error, the specified module
could not be found."

If I change it to

Dim Olapp As Outlook.Application
or
Dim Olapp As Object
Set Olapp = GetObject(, "Outlook.Application")

then it works fine as long as Outlook is open.

Why does the above work but the CreateObject line fail?

[Rick Brandt]

salad wrote:

I have the following code. I have a reference to the Outlook library
in the reference list. My machine is standalone, not on a network.

Dim Olapp As Outlook.Application
Set Olapp = CreateObject("Outlook.Application")

This blows up with the message "Automation error, the specified module
could not be found."

If I change it to

Dim Olapp As Outlook.Application
or
Dim Olapp As Object
Set Olapp = GetObject(, "Outlook.Application")

then it works fine as long as Outlook is open.

Why does the above work but the CreateObject line fail?

If you use late binding (good idea) then create all objects as objects.

Dim Olapp As Object
Set Olapp = CreateObject("Outlook.Application")

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[salad]

Rick Brandt wrote:

salad wrote:

>>I have the following code. I have a reference to the Outlook library
in the reference list. My machine is standalone, not on a network.

Dim Olapp As Outlook.Application
Set Olapp = CreateObject("Outlook.Application")

This blows up with the message "Automation error, the specified module
could not be found."

If I change it to

Dim Olapp As Outlook.Application
or
Dim Olapp As Object
Set Olapp = GetObject(, "Outlook.Application")

then it works fine as long as Outlook is open.

Why does the above work but the CreateObject line fail?

If you use late binding (good idea) then create all objects as objects.

In google groups it seems that some people experience the same error I
do while others do not.

>
Dim Olapp As Object
Set Olapp = CreateObject("Outlook.Application")

I get the same error "Automation error, the specified module could not
be found." with or without the Outlook Libary checked under
Tools/References it I use your method calling CreateObject. GetObject
works fine as long as Outlook is open.

[Rick Brandt]

salad wrote:

In google groups it seems that some people experience the same error I
do while others do not.

>>
Dim Olapp As Object
Set Olapp = CreateObject("Outlook.Application")

I get the same error "Automation error, the specified module could not
be found." with or without the Outlook Libary checked under
Tools/References it I use your method calling CreateObject. GetObject
works fine as long as Outlook is open.

I had one user getting that error and it was fixed by doing a repair install
of Office on her PC.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

[salad]

Rick Brandt wrote:

salad wrote:

>>In google groups it seems that some people experience the same error I
do while others do not.

>>>Dim Olapp As Object
Set Olapp = CreateObject("Outlook.Application")

I get the same error "Automation error, the specified module could not
be found." with or without the Outlook Libary checked under
Tools/References it I use your method calling CreateObject. GetObject
works fine as long as Outlook is open.

I had one user getting that error and it was fixed by doing a repair install
of Office on her PC.

That could be my case. One time I had O2K on my machine and had a
problem with Import/Export stuff on A97. I uninstalled both Offices and
reinstalled 97 but I installed it in another subfolder than the default.
Somehow I had 2 versions of A97 on the machine and I spent hours
trying to correct it. I finally got A97 back on but can't to this day
install service pack 2. I figure someday I'll get a new computer and I
won't have that problem with multiple versions of Access and perhaps
multiple crossfolder Access 97s and that problem will go away.

[David W. Fenton]

salad <oi*@vinegar.comwrote in
news:XB********************@newsread2.news.pas.ear thlink.net:

One time I had O2K on my machine and had a
problem with Import/Export stuff on A97. I uninstalled both
Offices and reinstalled 97 but I installed it in another subfolder
than the default.
Somehow I had 2 versions of A97 on the machine and I spent hours
trying to correct it. I finally got A97 back on but can't to this
day install service pack 2. I figure someday I'll get a new
computer and I won't have that problem with multiple versions of
Access and perhaps multiple crossfolder Access 97s and that
problem will go away.

Have you tried the Office 97 Eraser program? That's how I've always
been able to clean up failed/corrupted Office installations that
wouldn't completely uninstall themselves.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

[salad]

David W. Fenton wrote:

salad <oi*@vinegar.comwrote in
news:XB********************@newsread2.news.pas.ear thlink.net:

>One time I had O2K on my machine and had a
problem with Import/Export stuff on A97. I uninstalled both
Offices and reinstalled 97 but I installed it in another subfolder
than the default.
Somehow I had 2 versions of A97 on the machine and I spent hours
trying to correct it. I finally got A97 back on but can't to this
day install service pack 2. I figure someday I'll get a new
computer and I won't have that problem with multiple versions of
Access and perhaps multiple crossfolder Access 97s and that
problem will go away.

Have you tried the Office 97 Eraser program? That's how I've always
been able to clean up failed/corrupted Office installations that
wouldn't completely uninstall themselves.

I have NEVER heard of that program. I read some KB articles and did my
best to rid O97 using the recommendations. Is is a MS program or
external 3rd party program?

[David W. Fenton]

salad <oi*@vinegar.comwrote in
news:gT******************@newsread4.news.pas.earth link.net:

David W. Fenton wrote:

>salad <oi*@vinegar.comwrote in
news:XB********************@newsread2.news.pas.ea rthlink.net:

>>One time I had O2K on my machine and had a
problem with Import/Export stuff on A97. I uninstalled both
Offices and reinstalled 97 but I installed it in another
subfolder than the default.
Somehow I had 2 versions of A97 on the machine and I spent
hours
trying to correct it. I finally got A97 back on but can't to
this day install service pack 2. I figure someday I'll get a new
computer and I won't have that problem with multiple versions of
Access and perhaps multiple crossfolder Access 97s and that
problem will go away.

Have you tried the Office 97 Eraser program? That's how I've
always been able to clean up failed/corrupted Office
installations that wouldn't completely uninstall themselves.

I have NEVER heard of that program. I read some KB articles and
did my best to rid O97 using the recommendations. Is is a MS
program or external 3rd party program?

It's a Microsoft program. If you can't find it in the Knowledge
Base, I can put it up on my website for download.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

[David W. Fenton]

salad <oi*@vinegar.comwrote in
news:gT******************@newsread4.news.pas.earth link.net:

David W. Fenton wrote:

>salad <oi*@vinegar.comwrote in
news:XB********************@newsread2.news.pas.ea rthlink.net:

>>One time I had O2K on my machine and had a
problem with Import/Export stuff on A97. I uninstalled both
Offices and reinstalled 97 but I installed it in another
subfolder than the default.
Somehow I had 2 versions of A97 on the machine and I spent
hours
trying to correct it. I finally got A97 back on but can't to
this day install service pack 2. I figure someday I'll get a new
computer and I won't have that problem with multiple versions of
Access and perhaps multiple crossfolder Access 97s and that
problem will go away.

Have you tried the Office 97 Eraser program? That's how I've
always been able to clean up failed/corrupted Office
installations that wouldn't completely uninstall themselves.

I have NEVER heard of that program. I read some KB articles and
did my best to rid O97 using the recommendations. Is is a MS
program or external 3rd party program?

I should have checked my hard drive -- I had very cleverly saved a
link to the KB article for it!

(sometimes I'm so smart it kills me ;)

Here's the KB article, with a download link for the eraser utility:

http://support.microsoft.com/kb/q176823/

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

[salad]

David W. Fenton wrote:

salad <oi*@vinegar.comwrote in
news:gT******************@newsread4.news.pas.earth link.net:

>>David W. Fenton wrote:

>>>salad <oi*@vinegar.comwrote in
news:XB********************@newsread2.news.pas. earthlink.net:

One time I had O2K on my machine and had a
problem with Import/Export stuff on A97. I uninstalled both
Offices and reinstalled 97 but I installed it in another
subfolder than the default.
Somehow I had 2 versions of A97 on the machine and I spent
hours
trying to correct it. I finally got A97 back on but can't to
this day install service pack 2. I figure someday I'll get a new
computer and I won't have that problem with multiple versions of
Access and perhaps multiple crossfolder Access 97s and that
problem will go away.
Have you tried the Office 97 Eraser program? That's how I've
always been able to clean up failed/corrupted Office
installations that wouldn't completely uninstall themselves.

I have NEVER heard of that program. I read some KB articles and
did my best to rid O97 using the recommendations. Is is a MS
program or external 3rd party program?

I should have checked my hard drive -- I had very cleverly saved a
link to the KB article for it!

(sometimes I'm so smart it kills me ;)

Here's the KB article, with a download link for the eraser utility:

http://support.microsoft.com/kb/q176823/

Thanks, David.