when file is opened

[tintin1012000]

Hi again

I want to save a copy of my excel workbook in a network folder when i open my workbook, this i will use as a back up file incase its deleated.

Does any know code for this

Thanks

 

[VoG]

Try something like this in the ThisWorkbook module

Private Sub Workbook_Open()
Me.SaveCopyAs Filename:="Z:\" & Me.Name
End Sub