When running Excel jobs from the Job Server installed as a Windows Service you might run into different errors where Excel cannot function. The issue is a limitation imposed by Microsoft and it is not specific to Fusion. This applies to any program type including c#, VB, PowerShell etc. that uses OLE Automation.
There are many different solutions/configurations.
Please be EXTREMELY careful when modifying the windows configuration.
Here is the most common solution – Please note that it does NOT work for all configurations. So you have to experiment a bit.
Open Component Services (Start -> Run, type in
Drill down to Component Services -> Computers -> My Computer and click on DCOM Config
Right-click on Microsoft Excel Application and choose Properties.
- If you dont see Microsoft Excel yiou might be running 32 bit Office. Then use this command line to start the “Component Services”
Edit the user setting. Sometimes “The interactive user” works, sometimes “The user”.
Make sure the following folders exists.
Need more help with this?
DON'T HESITATE TO CONTACT US HERE ..