cbennetts
New Member
- Joined
- Feb 23, 2004
- Messages
- 29
Good Day all.
Here is the deal, I have a workbook which is called HM2005Nov23 that does automatic queries to the net every second. That runs just fine. When I get an error though (ie 1004) I want it to clone itself (modules and all) into another book that is titled the same but with a .1, .2, .3 etc. depending on how many times it has had to clone itself. After it clones itself I want it to delete the old version of itself and then start the web query again. Any suggestions?
Chet
Here is the deal, I have a workbook which is called HM2005Nov23 that does automatic queries to the net every second. That runs just fine. When I get an error though (ie 1004) I want it to clone itself (modules and all) into another book that is titled the same but with a .1, .2, .3 etc. depending on how many times it has had to clone itself. After it clones itself I want it to delete the old version of itself and then start the web query again. Any suggestions?
Chet