importing data into excel
 

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: http://www.excelforum.com/member.php...o&userid=34282
View this thread: http://www.excelforum.com/showthread...hreadid=541405

importing data into excel
 

While 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.


"integreat" wrote:


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: http://www.excelforum.com/member.php...o&userid=34282
View this thread: http://www.excelforum.com/showthread...hreadid=541405