Could anybody help me in fixing following problem in saving the shared workbook?
I have around 10 users sending data from their own worksheets to a shared workbook every day. When some users try to save the shared workbook, they encounter question like "The file exists already, do you want to replace it?" If the user chooses yes, then the original data in the shared file will be lost; if the user chooses no, then his/her data can not be sent to the shared file.
In every user's worksheet I put the following code:
Workbooks.Open ("G:\New Folder\T-H\Proof Sheet.xls"
Sheets("Proof Sheet".Select
...(save data)
ActiveWorkbook.Save
ActiveWorkbook.Close
ThisWorkbook.Save
ThisWorkbook.Close
Any suggestion is greatly appreciated.
JY
I have around 10 users sending data from their own worksheets to a shared workbook every day. When some users try to save the shared workbook, they encounter question like "The file exists already, do you want to replace it?" If the user chooses yes, then the original data in the shared file will be lost; if the user chooses no, then his/her data can not be sent to the shared file.
In every user's worksheet I put the following code:
Workbooks.Open ("G:\New Folder\T-H\Proof Sheet.xls"
Sheets("Proof Sheet"
.Select...(save data)
ActiveWorkbook.Save
ActiveWorkbook.Close
ThisWorkbook.Save
ThisWorkbook.Close
Any suggestion is greatly appreciated.
JY