Using a date string to name a backup

[mswantek]

Hello all!!
I am putting in some code to save a copy of a file to a network drive, for some reason though when I add the date string to the filename and path it bombs!!! Any thoughts? Without the

& strDate

it saves just fine, but I don't want to have to deal with the "already exists, do you want to overwrite" message........ saving the file with a date then makes it much easier for everyone..... Please help!!!!

Thanks.

Public Sub backup()
'ActiveWorkbook.Save
                Dim strDate As String
                strDate = Format$(Now, "hh:mm:ss mm-dd-yy")
                Application.ScreenUpdating = False
                On Error GoTo circumv1
ChDir "\\USWRNVS9FSH01\HZS66S$\PPO_forms\backups"

             ActiveWorkbook.SaveAs Filename:="\\USWRNVS9FSH01\HZS66S$\PPO_forms\backups\greensheetdata06backup " & strDate
   
               
               ActiveWorkbook.Close False

circumv1:
                Application.ScreenUpdating = True
End Sub

 

[lozzablake]

":" is a reserved character. you cannot use it in filenames

 

[mswantek]

So if I took the colons out it would work?

 

[lozzablake]

I would think so

 

[mswantek]

lozzablake,

Thanks. That is what it was.........

Mike