Object variable or with block variable not set

Yes I do have Outlook, but i dont know how to check if the CreateObject
is successful.

Set OutApp = nothing
on error resume next
Set OutApp = CreateObject("Outlook.Application")
on error goto 0

if outapp is nothing then
'something very bad happened
else
'it worked ok
end if



Piotr wrote:
>
> Yes I do have Outlook, but i dont know how to check if the CreateObject
> is successful.

--

Dave Peterson

Unfortunatly CreateObject("Outlook.Application") failed no idea ...

What error? Do you want to post the workbook at www.cjoint.com to look?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Piotr" <hokah@wp.pl> wrote in message
news:1135152843.332622.39060@f14g2000cwb.googlegroups.com...
> Unfortunatly CreateObject("Outlook.Application") failed no idea ...
>

Maybe this would give a hint:

Set OutApp = Nothing
On Error Resume Next
Set OutApp = CreateObject("Outlook.Application")
If Err.Number <> 0 Then
MsgBox Err.Number & vbLf & Err.Description
Err.Clear
End If
On Error GoTo 0

Piotr wrote:
>
> Unfortunatly CreateObject("Outlook.Application") failed no idea ...

--

Dave Peterson

Hi,
This was caused by Kaspersky Antyvirus, it was keep on blocking my
macros from executing in strange way.
Thanks for help

regards
Peter