I have written some code that is referencing outlook i.e. open outlook and I
am getting errors. When I go to load the Outlook object 11.0 I don't see this
there. I don't see this on the microsoft site.

How can a write a sub routine with out this? and load it in automatically
for the users that might use this?

Is the there something like Gord Dibben's
Private Sub Workbook_Open()
AddIns ("Analysis ToolPak").Installed = True
End Sub

that will do this?

Try dimming the Outlook object as Type Object instead of type
Outlook.Application, and instantiate it with say

Set OL = CreateObject("Outlook.Application")

instead of

Set OL = New Outlook.Application

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"gbpg" wrote in message
...
I have written some code that is referencing outlook i.e. open outlook and
I
am getting errors. When I go to load the Outlook object 11.0 I don't see
this
there. I don't see this on the microsoft site.

How can a write a sub routine with out this? and load it in automatically
for the users that might use this?

Is the there something like Gord Dibben's
Private Sub Workbook_Open()
AddIns ("Analysis ToolPak").Installed = True
End Sub

that will do this?