Hi,

I have a workbook which Imports Text from a File when it is First Opened.

Excel prompts me initally to either Enable or Disable automatic refresh and then imports this text data into the Workbook.

What I would like to do is as soon as it has finished imported the text into the Workbook, to then Sort the data in collumn B in Ascending order.

I thought I could do this using ThisWorkbook but the actual prompt to either enable or disable the refresh doesn't appear until the code runs.

I am not an expert on VBA so not sure how I would go about setting this up so any assistance would be greatly valued!