Permission Denied error when attempting OLE Automation to Excel

[Jim]

Hi everybody,

I'm having an issue when trying to do OLE automation to Excel in Access
2003.

Here's my code:

Sub test()
Dim xl As Excel.Application
Set xl = New Excel.Application ' Error occurs here
xl.Visible = True
End Sub

The error I get is error #70: Permission Denied.

I have installed Jet SP8 and set my security settings to Low, to no avail.
Has anybody got a solution to this problem?

Thanks, Jim

 

[Chris]

Had a similar problem on my machine with Word.
Problem turned out to be the default security settings in
DCOM.
Open the Start ~ Run Dialog box and type dcomcnfg and
check out the default settings

 

[Jim]

Thanks, that did the trick. I forgot that I was messing around w/ DCOMCnfg
a few months ago doing OLE automation from ASP.NET... Doh!

Jim