Using a date string to name a backup

mswantek

Board Regular
Joined
Jul 9, 2002
Messages
123
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
Code:
& 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.

Code:
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
 

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Forum statistics

Threads
1,141,914
Messages
5,709,313
Members
421,627
Latest member
bennhrios9

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top