Import data from TXT file and paste into Cell

**dgibson** · 01-25-2011, 01:46 PM

What I am trying to do is simple. Import all contents of text file at eg: c:\test\test.txt and paste into cell B:1 for example. The only data in said text file is "123456". This is not CSV or anything fancy.. just a single number string that I need to import using a macro.

Could somebody please help me out? Greatly Appreciated!

-Dave

**6StringJazzer** · 01-25-2011, 02:45 PM

If your data is on just the first line of the file then this will work:

Please Login or Register  to view this content.

**vihanay** · 05-18-2013, 06:53 AM

Hello!

In my case, I have several text files with sequence number on filename, e.g: day1.txt, day2.txt, etc.
Each files contain a hundred to thousand lines of barcode number:
B00009WE45
B0015YISKO
B007RFW1NA
...etc

How to group those data into one workbook in a row for each files as below?

Column1 Column2
day1 barcode-list
day2 barcode-list
...etc

I really high appreciate if somebody could help me.

Thank you.

**arlu1201** · 05-18-2013, 07:08 AM

vihanay,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.