scott-atkinson
I'm with the Witch.......
- Local time
- Today, 04:14
- Joined
- Aug 31, 2006
- Messages
- 1,622
Guys,
I have another problem..
I have written a comprehensive Macro to format a spreadsheet and save it as another name in another folder.
My problem is that when the code actions the save as it also copies the Macro to the new document as well, and I do not want this to happen.
So my question is how can I code in VB to delete the Macro from the newly named workbook?
Any ideas?
I have another problem..
I have written a comprehensive Macro to format a spreadsheet and save it as another name in another folder.
My problem is that when the code actions the save as it also copies the Macro to the new document as well, and I do not want this to happen.
So my question is how can I code in VB to delete the Macro from the newly named workbook?
Any ideas?