Macro for Import Text file and convert it in Excel

Today i am facing a problem...........i want to make many macro and try it on my Text file but nothing is going to right........

Below code i got from Recording Macro.........Below code including Text File opening + Set Break Line + Sort on COL-A and more more more................

i am looking for a solution, i want to make it dynamically......means that when i click on Commandbutton1, a open dialog box should be open like CTRL+O, where i choose my TextFile from my Desktop and it convert in Excel.........
Please see the excel file's Sheet Deletion

I am attaching 2files i.e. 1. TextFile and 2. Excel File, please see

Please Login or Register  to view this content.

After some amendments the below code is working for me but some bugs in it.......i want anyone can help to correct below mentioned code, please see:-

1. We are in Sheet1, When i click on Commandbutton1_Click(), a open dialog box will be open, if i click on Cancel Button it automatically import and convert the text file which you will see in the "TEXT;C:\Users\Gyan Verma\Desktop\July-2018 Advance\slgb0718.prn"

I want it should be worked on my choice of Text File and convert it in excel, so i want to correct this command line

by default it is always convert slgb0718.prn file

2. We are also in Sheet1, Click on Commandbutton1_Click(), now it create a sheet namely "Deletion" in existing workbook and data of Textfile should be in this "Deletion" Sheet.

Please Login or Register  to view this content.

Please correct it

please see the below code it gives me error on .Refresh BackgroundQuery:=False

Please Login or Register  to view this content.

You are welcome and thanks for feedback. As this seems to have solved your problem could you please mark thread "Solved" as per forum rules.

Alf

To mark your thread solved do the following:
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved

Thanks for help...........
Sir it is working fine but some issue are not solved in this code:-
my folder have "slgb0818.prn", "slgb1217.prn"
and it is always working on "slgb0818.prn" file because it have slgb0...prn in file name (Please see bold part is 0), if i will change my second file name from "slgb1217.prn" to "slgb0217.prn" then code is working. if file name contain 5th character 0 then it is working otherwise not working..........
and same case in .TXT file

2. i want to work on multiple extensions i.e. ".TXT",".PRN" how to add second extension in the code

Ok I've changed the code a bit and now you see both ".txt" and ".prn" files and macro runs without problems. But as you have not uploaded your "slgb0718.png" file I've renamed the "slgt718.txt" you uploaded to a number of different name vise that is png files.

Please Login or Register  to view this content.

Alf