There is a text file set up to automatically pull and compile data from multiple sources, and it refreshes once every day. I use that text source to populate some tables in my own spreadsheet, and have set up a query. I have a macro which I can currently run manually in order to refresh all the data, but it prompts me to select the text file containing the data I am importing each time. The file name or location is never going to change, so ideally I would like that refresh macro to run with a set frequency (I think I can figure that out with a bit of googling around), and also choose the text file automatically- I don't want there to be any manual selection of the data source.

Any help would be hugely appreciated.