Calling Excel using DCOM

M

Maury Markowitz

One of the machines on our network has a large library of Excel code I'd like
to call remotely.

I went to that machine and used dcomcfng to turn on access for "Microsoft
Excel Application" with Everyone set to full control.

When I attempt to call it with CreateObject("Excel.Application", "peterwrk")
I always get a "70, Permission Denied".

Is there anything else I have to do? I can make DCOM calls OUT from both the
client and server machines, and as far as I can tell, the server is properly
configured to allow DCOM calls and access Excel. Is there anything special I
need to do for Excel?

Maury
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Outlook Add-in - Javascript based using React JS - VS Code + WebPack - Unable to call external Web Service 0
React JS Outlook Add-in - VS Code + WebPack - Unable to call external Web Service - CORS Issue 0
How to pass parameters to excel from wscript (Windows script) 5
Calling a macro on a remote computer 0
DCOM Configuration: "The operation completed successfully" 0
Open excel file error in an ASP.NET (EventID 2001) 0
how to terminate Excel DCOM server in Matlab? 0
Missing DCOM Config entries for Excel & Word 0

Top