While running the code in a production server (unattended mode), I am getting an error when it is trying to run a basic select query in an excel and getting an error as below :
The connection for viewing your linked Microsoft Excel worksheet was lost.
I am getting this error on the exact same line where the select query is written and I was not getting this kind of error before (not even once!) . Surprisingly when I log in to the VM & run the code again, it runs fine.
Any suggestions or resolutions please ?
Best answer by PadmakumarView original