Multiple users updating excel spreadsheet
Is there a way, perhaps through VBA, that I can not allow a user to save while somebody else is opening the document? My question is, can it be done with all users working at the same time and when saving their work all data entered will go to one master excel sheet?if yes, would you be kind enough to share the code?I have experience with creating macros that reference different workbooks, but not sure how to go about opening files with different filenames (without referencing the exact filename).I'd like to be able to have basic code for opening, saving and closing, opening next file, saving and closing, etc. Thanks, Jason I would like to send an Excel file with hyperlinks of photo's attached to cells but when it is sent the recieving person cannot access the hyperlinks anymore. The file contains archive info that we do not have anywhere else.Our staff can't read and they keep opening additional copies of the file!I have read about sharing the file and I don't think that would make things any better.
I have an excel file in a LAN drive that is shared by a couple departments. has restricted access to this folder to a handful of people who are intimate with this project. This project has live for a few months now, so there is no need for more than one person to be in the file at a time.I'm concerned that changes will get over-written when 2 people are saving their changes. We have an Excel spreadsheet that sits on the network.People need to open the file to be able to sign up for various duty rosters.MS Access is not an option for me so I was wondering if you could help me do this in excel.thank you so much and would really appreciate to hear from anyone soon.