Hi,
I’m getting this error when I try to use excel application scope (visible option is turned off) in a background process (when executing from the orchestrator):
“Error opening workbook. Make sure Excel is installed.”
When I run it locally it works fine.
Is Excel application scope compatible with background processes?
Check if the Machine you are running is having Excel installed or not
Because Excel Application Scope will work if you the Excel installed in your system
Else you can use Workbook Activities, only thing is it will work for .Xlsx and .xls only
Hope this may help you
Thanks
The machine has Excel installed indeed. I’m using excel application scope because I’m executing a macro on a .xlsb file.
The thing is, the process works fine when I run it locally. I’m pretty sure the problem is not within Excel.
I have tried this in a different machine and the error persists.
This is what, if you are running in your machine and you don’t have any error
Are you sure that the other machine is having the excel installed in that machine?
As the error clearly saying that Excel to be install. Check which version of excel you installed locally and which excel in other machine?
Hope this way you can get to know
Thanks
Have you tried NOT running it as a background process? This is a basic troubleshooting step to see if the behavior is different. It’s possible a background process cannot use Excel Application Scope because it opens the Excel file which is not possible in the background.