Hi,
I’m recieving this error when running automation:
Read Range Workbook: Package object was closed and disposed, so cannot carry out operations on this object or any stream opened on a part of this package.
The problem is, that I get this error only when running it on VM. While running it just on my computer everything works properly.
Do you know why is this happening? Are there any rules/properties which has to be set for this activity or workbook while running it?
Hi @miladek
Use kill excel application in starting and at last. Ensure Use Excel Application Scope is properly configured and the file path is correct on VM…
Happy Automation
Hi, thank you for responding. 
But if I use classic activities, not the modern activities, I don’t need Use Excel Scope, right?
About path.. I’m sure it’s correct, checked it already many times.
The process looks like that:
Try upgrading the packages to latest possible version if not on latest already.
Try to use update the latest excel package and also use kill excel application in starting and end .
Hello @miladek
Could you experiment with the Excel activities as an alternative to Workbook?
Also try and edit the properties shown below.
Regards
Soren
Hi @SorenB,
thank you, it works
Do you have any idea why Read Range Workbook activity didn’t work?
Hmm it seems the program is in use or something like that.
You could try and restart the client machine if you want to use Workbook activities.
Hello,
thank you. All activities were updated to the last version.
The solution was that:
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
