Share one worksheet among 5 users to manage check-in process

StevegHI

Member
Hello,
I'm looking for ideas about the best way to have multiple users share a single spreadsheet (or maybe database) for check-in and voting purposes. We could have 100 people check in to 5 different and closely located computers. It would be much more efficient if they shared one spreadsheet. Ideas?
 
Some ideas:
1) Use another Excel workbook file that is not compiled into XLS Padlock, and use VBA to open/save this workbook from the main compiled workbook file.

2) Instead of relying solely on Excel files, consider integrating a centralized database (e.g., Microsoft Access, SQL Server) to store check-in and voting data. Each instance of the XLS Padlock-compiled application can connect to this database, allowing real-time data synchronization across all terminals. This approach minimizes data conflicts and ensures consistency.
 
Back
Top