Access9001
Registered User.
- Local time
- Today, 09:44
- Joined
- Feb 18, 2010
- Messages
- 268
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
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