Sometimes it is needed to set individual user permissions to chosen COM objects like (Excel). Here is short explanation what are these permissions and how to set them:
Dcomcnfg.exe provides a user interface for modifying certain settings in the registry. By using Dcomcnfg.exe, you can enable security either on a computer-wide or a process-wide basis. … Or you can use Dcomcnfg.exe to enable security for a particular application only.
And here is practical example how to use it:
- Reports generated in Excel don’t work invoked via VisualBasic Script using Windows Task Scheduler:
and set up:
Add Local Launch and Local Activation permissions to the Microsoft Excel Application DCOM Config.