Write, Bureaucrats, Administrators
2,725
edits
Difference between revisions of "Auto Upload"
Jump to navigation
Jump to search
no edit summary
| Line 48: | Line 48: | ||
== Required folders for auto upload == | == Required folders for auto upload == | ||
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. | 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 | This folder is required for Microsoft Excel 32-bit | ||
| Line 57: | Line 57: | ||
'''C:\Windows\SysWOW64\config\systemprofile\Desktop''' | '''C:\Windows\SysWOW64\config\systemprofile\Desktop''' | ||
=== Notes === | |||
* As stated before, they do not need to contain anything but they must be present. | |||
| Line 65: | Line 69: | ||
[[File:DCOMExcelDialogue.png|300px|thumb|right|DCOM Dialogue to configure Microsoft Excel]] | [[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. | 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. | To configure DCOM, follow these steps. | ||