Scandaemon as a Service, Excel Calculations for multi-component analyses
Issue: Scandaemon is running as a service and will not fire off excel calculations.
Solution: Follow steps 1 and 2 to resolve Excel Calculations not firing off when running Scandaemon as a service.
- Run the windows service as a user who has permissions on excel. Windows services generally run using the local account and these are mostly not configured to open excel. Double click on your windows service in services.msc -> Choose Log on Tab -> Enter interactive user account and password.
- Excel looks for certain folders in the system. A Desktop folder seems to be necessary in the system profile folder to open file by Excel. A lot of times, this solves a lot of excel automation issues.
For 64-bit (x64), create this folder: C:\Windows\SysWOW64\config\systemprofile\Desktop.
For 32-bit (x86), create this folder: C:\Windows\System32\config\systemprofile\Desktop