Load txt file into sheet on Open?

[JumboCactuar]

Hi, unsure how to do this from a
Txt file

In the following format

Name,Country
Jim Jones,Australia
Bob Frank,UK

Want it to load into my sheet "Users" and overwrite current contents.

Any help appreciated

 

[JonXL]

Hi, unsure how to do this from a
Txt file

In the following format

Name,Country
Jim Jones,Australia
Bob Frank,UK

Want it to load into my sheet "Users" and overwrite current contents.

Any help appreciated

Record a macro of you opening one of the files and then post it here.