software

Can excel read data from a text file.??

Example: lets say i type the following 4 lines using note pad:

23
100
344
134

and then save that to a file named test.txt

Now is there any way that excel can do the following?:

1. open test.txt

2. paste the data into the cells such as: the number 23 is in cell A1,
the number 100 is in cell A2, the number 344 is in cell A3 and the
number 134 is in cell A4

3. close test.txt

My hope is that excel can do this(with VBA help?), and if it can, then
I can use my trusty and rusty Qbasic and Quick basic for behind the
scenes hard core math.

Don't laugh - you can make machine language calls with quick basic but
can't with visual basic--
integreat
------------------------------------------------------------------------
integreat's Profile: www.excelforum.com/member.php...oamp;userid=34282
View this thread: www.excelforum.com/showthread...hreadid=541405While in Excel, go to file/open and select all files under file type. Then
open your file. You should see the text import wizard which will step you
through the process.quot;integreatquot; wrote:

gt;
gt; Can excel read data from a text file.??
gt;
gt; Example: lets say i type the following 4 lines using note pad:
gt;
gt; 23
gt; 100
gt; 344
gt; 134
gt;
gt; and then save that to a file named test.txt
gt;
gt; Now is there any way that excel can do the following?:
gt;
gt; 1. open test.txt
gt;
gt; 2. paste the data into the cells such as: the number 23 is in cell A1,
gt; the number 100 is in cell A2, the number 344 is in cell A3 and the
gt; number 134 is in cell A4
gt;
gt; 3. close test.txt
gt;
gt; My hope is that excel can do this(with VBA help?), and if it can, then
gt; I can use my trusty and rusty Qbasic and Quick basic for behind the
gt; scenes hard core math.
gt;
gt; Don't laugh - you can make machine language calls with quick basic but
gt; can't with visual basic
gt;
gt;
gt; --
gt; integreat
gt; ------------------------------------------------------------------------
gt; integreat's Profile: www.excelforum.com/member.php...oamp;userid=34282
gt; View this thread: www.excelforum.com/showthread...hreadid=541405
gt;
gt;