VB and Excel

I have an Excel spreadsheet with 2 worksheets in it. What I want to do is add a VBA macro to delete the contents of worksheet 2 and automatically open a delimited text file into it (i.e. a refresh of the data). How do I do this? There is no Worksheets("Sheet2").Open command.

I am using Excel 2000 but it also has to work on Excel 97.

Any help appreciated.

Many thanks
JP

Easiest way of makin' Excel macros is to record 'em. Turn on recording, do what you want the Macro to have, turn off recording and copy the resulting commands to where you need 'em. No muss, no fuss.