How do I export a worksheet into an existing or new workbook?

[Access9001]

What would be the code for doing the following (I've tried all sorts of ways and I can't get it to quite work right, so I'm just starting from scratch):

1. Check if destFile exists
2. If it does, save current sheet destName in new workbook labeled destFile
3. If destFile exists, check if worksheet destName exists in destFile
4. If it does, delete it and replace it with the new destName sheet
5. If it doesn't, insert destName sheet

 

[GinaWhipp]

This should get you started...

http://www.accessmvp.com/KDSnell/EXCEL_Export.htm#WriteRstFile