Import text file

Originally Posted by bigmack

Hi,

you can use the Open statement:

Open "your directory path\file name.txt" for input as #1

then read through each line within a loop until EOF. What part(s) of the text file are you specifically looking for?

I need information as follows and data to be entered as 1 row

Header
Item Number, Description, last shipment, last receipt, Average Unit Cost, Stocking Unit, Qty on Hand, additional Information.

Data
47, lamp, dd/mmm/yy, dd/mmm/yy, ###,000.00, EA, 50.00, K5501

I'm self-taught myself in vba, I understand loop code if i work on spreadsheet. however for this I cannot figure out how to capture data in a text file.

any ideas or example with some explanation will be helpful for me.