Now I get Runtime error 1004
Application defined or object defined error. And this line highlited:

.ListObject.DisplayName = "x"



Screenshot2.jpg

Also it looks like it's going to open up a new sheet to load the import into, but I wanted it on the same sheet as the user is presented with at the start, and where they trigger the macro.