You are currently viewing the Excel VBA section of the Wrox p2p Programmer to Programmer discussion community. This is a community of more than 40,000 computer programmers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining our free Wrox p2p community you can post your own programming questions and respond to other programmers’ questions. Registered users also don't have to see the ads that are displayed to guests. Registration is fast, simple and absolutely free so please, join today!
Join today and post to win prizes! Post more to increase your chances of being Wrox’s top poster of the month.
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
