I am using following vb code to save file with cell range;
I need to amend it that if file already save with this name, it should save the file with extension for example, if file name ABC.xlsb already there, it saves as ABC (1)
Dim Path As StringDim filename As String
Path = ThisWorkbook.Path & "\Backup" & ""
filename = Range("O6")
ActiveWorkbook.SaveAs filename:=Path & filename & ".xlsb", FileFormat:=50
Application.DisplayAlerts = False
I need to amend it that if file already save with this name, it should save the file with extension for example, if file name ABC.xlsb already there, it saves as ABC (1)