Posted: 24 May 2019 5:50 EDT Last activity: 18 Jun 2019 4:44 EDT
Excel connector session lost
A RDA uses an excel connector with Visible component property = False.
In automation also excel Visible property is set to False.
But if a user opens another excel file during the automation run, he sees the automation excel file openened behind his one.
Then, the automation looses its excel control and gets an error since it doesn't succeed in filling cell i.e. using excel: Error executing link in Automation: ... Invalid worksheet cell: ...
Are there other properties or ways to get an excel session only for the automation to avoid that resources conflict?
Thanks in advance
Let me know which version of Robotics you are using at your end. Have you tried setting visible parameter to 'true', if not try once as by setting visible to false the main excel will not be visible for runtime.