update excel with data from text file??

  • Thread starter Thread starter PAkerly
  • Start date Start date
P

PAkerly

I want to update excel with data from a text file...is this possible?

Basically I have a text file that has a lot of stuff in it but I am
interested in the lines that begin with *D

so those lines would look like this:
*D11200120 12 250
*D25012002 18 111
etc...

And so I want to update an excel file and a certain sheet within this
file
so cell would be updated as follows:
B2 = *D11200120
C2 = 250
B3 = *D25012002
C3 = 111
etc.

Can anyone give me examples of how to do this?
 
I want to update excel with data from a text file...is this possible?

Basically I have a text file that has a lot of stuff in it but I am
interested in the lines that begin with *D

so those lines would look like this:
*D11200120        12     250
*D25012002        18     111
etc...

And so I want to update an excel file and a certain sheet within this
file
so cell would be updated as follows:
B2 = *D11200120
C2 = 250
B3 = *D25012002
C3 = 111
etc.

Can anyone give me examples of how to do this?
Click to expand...

Gee something as simple as that can just be scripted. You could
effectively import in to excel and use like a VLOOKUP on a loop
through the whole file... Look up and learn that function and see
where it takes you.

Jess.
 
Back
Top