dim i as long
dim x as string, y as string
x = "Dateiname mit Pfad ohne Dateiendung"
if dir(x & ".xlsb") <> "" then
for i = 1 to 9999
y = x & "(" & i & ")"
if dir(y & ".xlsb") = "" then
x = y
exit for
end if
next
end if
activeworkbook.saveas x, 50