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 correct it
Bookmarks