Save As method

[Forestq]

hi,

I want to save WB with method saveas:

    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

 

[s hal]

because forward/back slashes are not valid in a file name

 

[Forestq]

so how can I add the date at the end of the file name ?

 

[s hal]

use something other than a forward or backslash.. periods or hyphens work pretty well, as do underscores or simply spaces.

 

[Forestq]

I did as below and is ok now:

Dim DefaultDate As Date
    DefaultDate = Now()
   
    Incidents2013.SaveAs ("All Incidents Since Jan 2013 " & Format(DefaultDate, "YYYYMMDD") & " .xls")