Since one of the computers on my network has upgraded to the office 2003
service pack 2 on auto upgrade the following procedure no longer works


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

the program in question says it can not create the
ActiveX control?
never got this error before the update


if i am using outlook i can use
set olapp = outlook.application


but not when I using excel because I have to use late binding because some
users have 2000 some 2003 some xp.

anybody know why this is or maybe another way to do this?



--
When you lose your mind, you free your life.

Hi

Some anti-virus applications have script blockers that don't allow the use of the Outlook.Application object.
Maybe test it without ?




--
Regards Ron de Bruin
http://www.rondebruin.nl


"ben" (remove this if mailing direct) wrote in message
...
Since one of the computers on my network has upgraded to the office 2003
service pack 2 on auto upgrade the following procedure no longer works


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

the program in question says it can not create the
ActiveX control?
never got this error before the update


if i am using outlook i can use
set olapp = outlook.application


but not when I using excel because I have to use late binding because some
users have 2000 some 2003 some xp.

anybody know why this is or maybe another way to do this?



--
When you lose your mind, you free your life.

I amn having the same problem, the error I get is:

Automation Error The specific module could not be found

I think it must have something to do with SP2...

ben (remove this if mailing direct) wrote:
Since one of the computers on my network has upgraded to the office 2003
service pack 2 on auto upgrade the following procedure no longer works


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

the program in question says it can not create the
ActiveX control?
never got this error before the update


if i am using outlook i can use
set olapp = outlook.application


but not when I using excel because I have to use late binding because some
users have 2000 some 2003 some xp.

anybody know why this is or maybe another way to do this?



--
When you lose your mind, you free your life.