|
|
| Line 44: |
Line 44: |
| * When browsing to the Auto Upload.xls file, ensure that the path is a UNC path and not a mapped drive. A UNC path begins with the server name. | | * When browsing to the Auto Upload.xls file, ensure that the path is a UNC path and not a mapped drive. A UNC path begins with the server name. |
|
| |
|
| | == Configure required folders for Auto Upload and Scheduled Tasks == |
|
| |
|
| | In order for newer versions of windows to run excel spreadsheets as a scheduled task, see [[Configure required folders for Auto Upload and Scheduled Tasks]]. |
|
| |
|
| == Required folders for auto upload == | | == Configure DCOM settings for Auto Upload and Scheduled Tasks == |
| | |
| In order for newer versions of windows to run excel spreadsheets as a scheduled task, the following folders must exist. The default windows setup may not have created them. While these folders do not need to contain anything, they are required by Excel somehow in order to launch correctly. If they are missing, it is possible that the scheduled task will launch but excel will not run any code or macros (e.g. you will see excel.exe in the task manager but it will be using 0% CPU).
| |
| | |
| This folder is required for Microsoft Excel 32-bit
| |
| | |
| '''C:\Windows\System32\config\systemprofile\Desktop'''
| |
| | |
| This folder is required for Microsoft Excel 64-bit.
| |
| | |
| '''C:\Windows\SysWOW64\config\systemprofile\Desktop'''
| |
| | |
| === Notes ===
| |
| | |
| * As stated before, they do not need to contain anything but they must be present.
| |
| | |
| | |
| | |
| == Required DCOM settings for auto upload ==
| |
| | |
| [[File:DCOMDialogue.png|300px|thumb|right|DCOM Dialogue]]
| |
| [[File:DCOMExcelDialogue.png|300px|thumb|right|DCOM Dialogue to configure Microsoft Excel]]
| |
| | |
| 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 it 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).
| |
| | |
| To configure DCOM, follow these steps.
| |
| | |
| # From the windows '''Start''' menu, type '''run''', and then '''mmc comexp.msc /32''' for 32-bit excel or '''dcomcnfg''' for 64-bit excel;
| |
| # Navigate to '''Component Services''', then '''Computers''', then '''My Computer''' and click on '''DCOM Config''';
| |
| # Find '''Microsoft Excel Application''', right-click on it and choose '''Properties''';
| |
| # In the Security tab, under '''Launch and Activation Permissions''', select '''Customize''', click '''Edit''' and add the required account or user group;
| |
| # In the Security tab, under '''Access Permissions''', select '''Customize''', click '''Edit''' and add the required account or user group;
| |
| # In the Security tab, under '''Configuration Permissions''', select '''Customize''', click '''Edit''' and add the required account or user group;
| |
| # In the Identity tab select '''The launching user''' and ensure the user used for the scheduled task is correct;
| |
| | |
| <br clear=all>
| |
|
| |
|
| | In order for newer versions of windows to run excel spreadsheets as a scheduled task, the related DCOM components must be created correctly. For more information, see [[Configure DCOM settings for Auto Upload and Scheduled Tasks]]. |
|
| |
|
| == Related Topics == | | == Related Topics == |