One Text file (*.txt) for multiple user input

[ARUNCHENNAI]

Hi,
I created a macro in excel (open as ready only, so that many users can access at a time) and allowed to write the contents to a .txt file.

How to make it possible to allow the .txt file to accept multiple users entries if, entered at the same time. or How to make the user to wait till the file close.

Please help.

Arun

 

[rlv01]

Excel is not very good at managing simultaneous multi user access. It was not designed for that. The only way I've made it work in a large team environment was to use a 3rd party subversion client like TortoiseSVN. Without something like that, it too often results in work by other team members getting overwritten by the last person to save the shared workbook. If team collaboration is paramount, there are other applications such as SmartSheets that have it built into their DNA.

 

[ARUNCHENNAI]

Thank you rlv01.