Extract text and save as new file

[SMHSleepy]

Hello all,

Just a shot in the dark here but is there a way to read a rtf file, extract just the first 5 lines of text (or the last 5 lines, whichever is easier) and save it as a txt file?

For example, my rtf file begins with:
INDEX FILE
0123456
28/02/2011
REPORT NAME
FILE_NAME.RTF
.....
.....

I need to create a txt file containing just these 5 lines. Currently, I have to manually copy and paste these into a new txt file but I'd like to be able to automate the process using VBA code. Any suggestions?

 

[Alt255]

If you haven't already done so, post this in the VBA forum. You will receive a much better answer.

Add water (makes its own sauce).

 

[SMHSleepy]

Thanks for the suggestion but I already figured it out. Cheers!