Configure DCOM settings for Auto Upload and Scheduled Tasks

From ODBClink wiki
Jump to navigation Jump to search

Overview

In order for newer versions of windows to run excel spreadsheets as a scheduled task, the related DCOM components must be created correctly.

DCOM is used to allow applications to communicate with each other. In this case, it is use by the task scheduler to talk to Excel. If DCOM is not configured correctly, it is possible that the task will not even launch (e.g. you will not see excel.exe in the task manager).

Configure DCOM settings for Auto Upload and Scheduled Tasks

DCOM Dialogue
DCOM Dialogue to configure Microsoft Excel

To configure DCOM, follow these steps.

  1. From the windows Start menu, type run, and then mmc comexp.msc /32 for 32-bit excel or dcomcnfg for 64-bit excel;
  2. Navigate to Component Services, then Computers, then My Computer and click on DCOM Config;
  3. Find Microsoft Excel Application, right-click on it and choose Properties;
  4. In the Security tab, under Launch and Activation Permissions, select Customize, click Edit and add the required account or user group;
  5. In the Security tab, under Access Permissions, select Customize, click Edit and add the required account or user group;
  6. In the Security tab, under Configuration Permissions, select Customize, click Edit and add the required account or user group;
  7. In the Identity tab select The launching user and ensure the user used for the scheduled task is correct;


Related Topics