Dear Experts,
Greetings!

As per my below query, I have received response that it is not possible. Looking forward can we make such code that when a Data.xlsx is in use, the data from User file will be save automatically in a temporary file and as the data.xlsx will be ready to use, the data should copy from temporary file and paste in to the Data.xlsx file....?

Just think about my logic and if possible please provide codes for the same.

Thanks

Details: -
(I am happy to say that being a member of the forum and learn a lot of methods.
By collecting many codes i am able to do many useful files for my team to reduce usage of time.
Recently I am working on a project. Below are the key activities: -
1) There are 4 Projects for which engineering team are working
2) For Each Project one Master sheet which contains total drawing master for this project.
3) The respective engineers, they want to send drawings to the respective reviewer.

For these above activities, I have made Engineer's Wise One DRRF.xlsm file (For All engineers same format, only the file names are changed as per their Emp No.) and stored on a shared folder.
I have kept the Master list of drawing files (data.xlsx) also in the same folder.
Now, whenever any engineer wants to send any drawing for review, they are using DRRF.xlsm (For their name) where they are selecting project, entering document numbers and then submitting for review.
Once they are submitting, the data.xlsx file open and copy the requested document detail from DRRF.xlsm save and close the database.xlsx file. then form the opened file (DRRF.xlsm) it goes to reciepents using outlook and make drrf as pdf as attachment.

Only the problem is when more than one engineer make review request and the data.xlsx being used by any user, another user is unable to proceed because his data is not copied in data.xlsx file.
What will be the best way that no any user will stuck. Also note that data.xlsx is saved as shared file.

Please read above and guide me to make this file error free for users)