Can you please have a short look on the attached picture, in the last row of a file there is a EoF sign something. Do you have maybe idea what does it mean?
This file is refreshed everyday by a txt file, with steps
1) Open yesterday excel file
2) Right click on any cell and selecting Refresh
3) Pop-up window comes up to select a .txt file
4) Selecting the .txt those rows are coming to the sheet
Basically I can not see any macro in the file, maybe it is not allowed to see I am not sure. Do you think such kind of right click/refresh and selecting .txt is a method to initiate a macro run, or maybe some other method?