You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of computer programmers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other programmers’ questions, win occasional prizes given to our best members, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
I have an excel database with VBA-code. The data must be filled in the xlsm-file from 4 different PCs. My question is if it is possible two users to open and edit the same xlsm-file located on a server. All PCs have Microsoft Office 2007 Enterprise.
How are your users connecting to and opening your VBA Excel 2007 .xlsm file ?
If they are opening the file directly over an office network or LAN , only one person may open the file at one time for reading AND writing. Once a user opens the file it becomes locked to other users allowing them to open it for 'read' purposes only.
When the first user is done with the file and closes it, the 'write' lock is released allowing once again another user to open it for writing.
If you'd like for multiple users to be able to write to the file simultaneously you might want to look at giving users access to the file through a web interface or even via Excel which connects to a central excel file (or better still to a proper database application) using ADO.
Multiple users working on the same xlsm - file
Multiple Users Opening Excel 2007 File Simultaneously
Linear Mode
