Good day,

 

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.

 

Julian