Import text file with the help of VBA

Question

Hello Everyone,&nbsp;&nbsp;I have tried VBA code and its work. But&nbsp;If our original Workbook has No data in sheet 1,&nbsp; It Starts adding other sheets. It's not Started filling with sheet one.like -&nbsp; I want to start the code with the first sheet and for other data it also add a new one.&nbsp;So, what should i write in VBA code?&nbsp;Please help..&nbsp;Here is a attached file..

hansvogelaar · Accepted Answer

Excel&nbsp;
I'd delete the empty sheet at the end of the code:
    Application.DisplayAlerts = False
    Worksheets(Worksheets.Count).Delete
    Application.DisplayAlerts = True

Forum Discussion

Import text file with the help of VBA

Share

Resources