Techibee.com

The machine-default permission settings do not grant Local Activation permission for the COM Server application with CLSID {00024500-0000-0000-C000-000000000046} to the user

You might get subjected error message when you run some script/vbapplication which interacts with Office products like word, excel, and Outlook through a cron/scheduled job. The reason for failure here is, problem with DCOM permissions. To resolve this issue, follow the below steps.

  1. Go to the Start-Run menu item.
  2. Type in “DCOMCNFG” and hit enter.
  3. This should load the “Component Services” MMC (you can also load from Administrative Tools – Component Services”
  4. Expand “Component Services”
  5. Expand “Computers” 
  6. Select  “My Computer”
  7. Select the “DCOM Config” item
  8. Select the “Microsoft Excel Application” item.
  9. Right click and select Properties
  10. Select the Security Tab
  11. Under “Launch and Activation Permissions” select the “Customize” option.
  12. Click the “Edit” button
  13. Click the “Add” button to add the account using which you are running the script/vb application

This should solve your problem. This solution works for all Office applications like Excel, word, and outlook as well. Only thing you need to do is, select respective office application properties instead of Excel in above procedure.

Happy Learning..,
Sitaram Pamarthi

Exit mobile version