i added a workbook using VB in Excel by using the code:
Workbooks.add
and then saved it as another file with
ActiveWorkbook.saveAs("Filename.xls")

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?

Application.DisplayAlerts = False
ActiveWorkbook.saveAs("Filename.xls")
Application.DisplayAlerts = True

thanks for your help :)