VBA Macro text import memory error

I´m not an expert on creating macros, but with help found here i managed to create a button that imports a text file to a specific sheet Works perfectly in my testruns on Office 2010, but in office 2013 i get the dreaded "Out of memory"
This is my coding..Debugger tells me the problem is the last line (.Refresh BackgroundQuery:=False)
I suspect it´s because excel opens the file, but doesn´t drop the connection after the text import.

Please Login or Register  to view this content.

In a perfect world, the user should only press the button ONCE, but sometimes they forget that, and presses it more than once, thus opening a new connection each time.

Thanks, but am I doing something wrong? when I run it (push the button) It quickly opens a new worksheet/workbook, and then closes it again. I can see that it gets the data alright, but they´re not doing me any good if it closes the sheet again

Sweet -Now i just need it to open in the already active workbook instead of a new. Button on ark1, data imported to ark2
Attached the excel sheet, and the textfile i need to import.