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