aliaslamy2k
Active Member
- Joined
- Sep 15, 2009
- Messages
- 416
- Office Version
- 2019
- Platform
- Windows
Dear All,
I have created a workbook which will be used by multiple users in network drive. I am using below VBA code for a backup but this creates a back for any one user, because all other users are having different path for same network drive. E.G. D:\ , Z:\ , M:\ , L:\ H:\ ...but all users are accessing same network drive with different path name.Please advise to modify the below code so that I should get back up of my workbook from all users?
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
ThisWorkbook.SaveCopyAs "X:\BACK UP\BACK UP" & ThisWorkbook.Name
End Sub
Kind Regards,
AB
I have created a workbook which will be used by multiple users in network drive. I am using below VBA code for a backup but this creates a back for any one user, because all other users are having different path for same network drive. E.G. D:\ , Z:\ , M:\ , L:\ H:\ ...but all users are accessing same network drive with different path name.Please advise to modify the below code so that I should get back up of my workbook from all users?
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
ThisWorkbook.SaveCopyAs "X:\BACK UP\BACK UP" & ThisWorkbook.Name
End Sub
Kind Regards,
AB