I created a VBA macro with a RTD (Real time data) connection to capture some data in real time for an excel spreadsheet.
It happens that from time to time, when the macro runs, sometimes the code stops and Excel gives the following message:
"The realtime data server 'rtd.trading.rtdserver' is not responding. Do you want Microsoft Excel to try restarting the server?"
If I don´t click on the yes option, the code is interrupted and does not execute.
How do I stop this message from appearing?
Any tips?
