Dear all, I have the following code, which saves a backup of the file
being opened. I would appreciate your help on changing it so that it
saves into a directory called \backup in the same file path.

Many thanks for any help !
love Amy xx

Private Sub Workbook_Open()
Dim sStr As String

sStr = Format(Now, "yyyymmdd hh-mm")

Me.SaveAs Filename:=Me.Name & " " & sStr, _
FileFormat:=xlWorkbookNormal
End Sub


--
AmyTaylor
------------------------------------------------------------------------
AmyTaylor's Profile: http://www.excelforum.com/member.php...o&userid=20970
View this thread: http://www.excelforum.com/showthread...hreadid=500532