hi,
I want to save WB with method saveas:
Why I got error like:
run-time error '1004'
Method 'SaveAS' of object '_Workbook' failed
I want to save WB with method saveas:
Code:
Dim DefaultDate, Now2 As Date
DefaultDate = Now()
Now2 = Format(DefaultDate, "dd/mm/yyyy")
ABC.SaveAs ("Today " & Now2 & " .xls")
Why I got error like:
run-time error '1004'
Method 'SaveAS' of object '_Workbook' failed