I am writing to you because I am experiencing some issues with VBA and some Reuters routines.
To summarize the situation:
I used a VBA code with the goal to open a specific file to update Reuters prices (TR formulas in different sheets) and after, I copy the data in another file.
It was working well during 3 months but now, since 4/5 week Excel crashes (and closes) every time I am trying to update the prices. I commented the Reuters routine and the VBA code is running well. When I launch the Reuters routine, it crashes.
The Reuters routine I am using are:
Function Workbook_RefreshAll_2(Work_to_refresh As Variant)
Application.Run "EikonRefreshWorkbook", True, 3000
I tried with another Reuters routine but it is the same issue:
Do you know what could be wrong? Do I have to update some Add-Ins or tools?
Do you know the reason why Excel is crashing?
Thank you very much for your help.