i added a workbook using VB
in Excel by using the code:
and then saved it as another file with
However, every time i run this script, a message comes up telling me that the file already exists.
Is there a way I can overwrite this file through Excel VB
automatically? Does such a method exist in Excel vbe?