Parse a WorkSheet.

[pmking]

What is the VBA code/method to parse an excel worksheet.

I am searching in various places to find the code/method to parse worksheet1 and once the specific keyword is found, I need to grab what is after the keyword and a comma and two spaces <example: Keyword, 12345.34>. And place 12345.34 into worksheet2.

Is the method parseLine? I have been working with the parseLine method, but I am not having luck..

Thanks.

 

[PHV]

And what about the Find method of the Range object ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[PHV]

I have been working with the parseLine method
????
method of which object ?

 

[pmking]

Okay,

Lets ask it this way, I am not sure what PHV meant with your question.. Sorry if I did not ask the right question, I am learning here.

All I want to do is parse worksheet 1 for different values and capture what I parsed from Worksheet 1 and paste into Worksheet 2. Can this be done using Excel VB?

What can I search on within the VB help to assist me in finding a solution?

 

[PHV]

Reread my first reply.

 

[pmking]

Thank you PHV..

I have not found much under your suggestion, but as I was looking further using your keyword, I found.. MatchTextExactly Property. I am not sure what I will do with this, but it seems like I am on the right track.

Do you agree?


Thanks PHV..