How can I delete a file with a macro (Excel97)?

Posted by GMT on August 18, 2000 1:17 AM

How can I delete a file with a macro (Excel97)? For example, I wanna sort, make subtotals, show level 2, and then copy visible cells to a new file and then delete the old file.

Posted by David on August 18, 0100 1:22 AM

Ryans answer

3675.html

Posted by GMT on August 18, 0100 1:43 AM

Re: How can I ...

Thanks!
How can I make to run this macro as self-acting (automatic) when I open the file?