OpenText Method with "StartRow" as a variable

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JingleRock - 20 Sep 2007 19:46 GMT

I need to parse a text file and paste the result in the active
workbook. I need "StartRow" to be the same row (a variable row
number) that contains the word "SALES" in the text file. Is this
possible?
TIA

Reply to this Message

Jim Cone - 21 Sep 2007 00:18 GMT

Suggest you use the Find method to determine the row.
It returns a range object so the row would be something like...
rngFound.Row

Signature

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)

"JingleRock" <cgrob@houston.rr.com>
wrote in message
I need to parse a text file and paste the result in the active
workbook. I need "StartRow" to be the same row (a variable row
number) that contains the word "SALES" in the text file. Is this
possible?
TIA

Reply to this Message

JingleRock - 22 Sep 2007 05:00 GMT

Jim,

Thanks very much for your advice.
I decided to junk the OpenText Method because I have a need to use 4
different "parsing rules" on my text file (I used 2 worksheets to
receive the parsed results). I ended up looping thru my text file and
using stmts such as:
Cells(Counter, 1).Value = "" & Mid(TextLine, 1, 8) to do my parsing.
But I did have a use for the Find Method when selecting certain
cells, and pasting them 2 columns to the right of the search column)
in the same row as the "Found" string. And its fast.

Thanks again,
Chuck

Reply to this Message