ExcelBanter - Refresh rate in getting external data from file

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Refresh rate in getting external data from file (https://www.excelbanter.com/excel-programming/280334-refresh-rate-getting-external-data-file.html)

CY459

Refresh rate in getting external data from file

I currently have Excel set up to get external data from a
text file. The minimum refresh rate that I can set is 1
minute. Does anyone have a macro that would be able to
increase the refresh rate to 5 seconds without causing a
stack error?

All times are GMT +1. The time now is 08:44 AM.