Excel and VB!!

[leo_83]

Hallo comrades,

I am a newbie in VB and I need your assistance to complete my assignment

The task is :

1 ) Open Excel file -->>> Sucessfully done & working

2) This excel file contains 3 important strings

BEG_Spe

$ Package_N: <Package_N>

End_Spec

the VB program must be able to search first BEG_spe (Starting of information)

3)BEG_spec= found , Search for $ Package_N:

if found, Read the contents in <Package_N>

and print them to A .txt/ any other file anywhere on computer

4)keep on searching till End_Spe is found
End_spec = found

End the program

It could be that in between $Package_N: and $ End_spe, there are some more strings with $,

EG: $Abcd: <pqrs>

then we need to also print this as pqrs in txt file

I need proper guidance to this assignment, any help is highly appreciated.

Please note this is VB and not VBA.

To avoid complications , we can for the moment assume that all the $Package_N and End_spec and Beg_Spec occur in same column.

thanks

Abhi