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" <(E-Mail Removed)> wrote in message
news:8D8F7186-CDB4-4D23-8463-(E-Mail Removed)...
>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?