using vba to import text into excel

[ace323]

Hello all- glad I found your forum!

I have a question:

I'd like to know if/how this is possible using vba.I'd like excel to "scan" a text file and import:

1.ALL the lines of text before a line that contains a certain character , * for example

2. ONLY text thereafter that is bound in parenthesis.

Total newbie, any help would be greatly appreciated

Thanks Alot,

Scott L.

[MSP77079]

Two options:
1. just open the entire file as an Excel file, and delete what you do not want; this is easiest, as you can use the macro recorder to get started and then edit

2. open the text file as a textstream and use VBA logic to process the textstream one line at a time