HELP PLEASE!

Code:
    Do While Not Rs.EOF
        Rs.Delete
        Rs.MoveNext
    Loop
I am calling the above from Excel, rs is my imaginatively named variable for a recordset.

All I would like to do is delete everything from a recordset when Excel closes (keeping column headers etc, would prefer not to create table each time Excel page starts). Can anyone point me in the right direction here please?

Thank you! this is GREATLY appriciated as this is just starting to get to me...
Alex read