Our organization is using the office edition to download reports data to excel. This downloaded data every x minutes, gets formated using a macro, and sent automatically to a partner's email address. This works all fine, until the session times-out (user seems to be still logged in).
Is there any code that I can add to my excel workbook to keep the connection alive, or reconnect the lost connection, etc?
Or may be any other solution?
Thank you very much.