I have a text file that needs to imported regularly into XL, without user intervention.

I've tried creating a macro, but during file selection the text file columns are awaiting user enforcement.

I have created an Export Template that allows XL to Text as user required format, so surely, there must be a way to automate the reading of this text file - then I will have another macro to for autocalculation within the spreadsheet.
TIA