<div>
Thank you Macro for a quick solution. The code is working. But the code is writing in the first row. I would like the first row to be left as I have to write a header information.<br />
The first row should have Title, Color and Year.<br />
Only from the second row the text file records should be imported.<br />
Is there a possibility to remove the duplicates when importing the text file into excel file. Thanks.
</div>


Thank you Macro for a quick solution. The code is working. But the code is writing in the first row. I would like the first row to be left as I have to write a header information.
The first row should have Title, Color and Year.
Only from the second row the text file records should be imported.
Is there a possibility to remove the duplicates when importing the text file into excel file. Thanks.

<div>
Change row 19 to<br />

<pre><code id="code-20-40194102-1">RowNdx = ActiveCell.row + 1</code></pre>
</div>


Change row 19 to


RowNdx = ActiveCell.row + 1

<div>
Removing duplicates is a separate issue and should be asked in a separate question.
</div>


Removing duplicates is a separate issue and should be asked in a separate question.

<div>
<div class="content wysiwyg-content">
I need to import a text file into excel using VBA.<br />
The Excel file has the first row as the Column names. The text file values are separated by tab delimiter. <br />
I would prefer a icon on the excel tab to run this macro. Thanks.
</div>
</div>


I need to import a text file into excel using VBA.
The Excel file has the first row as the Column names. The text file values are separated by tab delimiter. 
I would prefer a icon on the excel tab to run this macro. Thanks.

need to import a text file into a EXCEL using VBA.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.