I posted this question on Saturday and didn't get a great anser. Thought I
would repost during the week when more people will read the posting.

I don't have a lot of experience with shared workbooks in Excel and not sure
what will happen if two people try to write the file at the same time.

1) What is the best method with Excel 2003 and Excel 2007 for sharing a
workbook and letting multiple users write file through Excel VBA? Also
simulataneously allowing users to read the file as a worksheet. Do you need
to lock the file during the writes. Obviously, the readers won't get any
updates to the file that are made will the book is opened.


2) Is it better to use Access instead of Excel? I would think more people
know how to use Excel than Access so Excel would be the preferable way of
going.

3) Would using GETOBJECT("book1.xls") from excel work? Can two users open
the workbook for writing and both be able to write data successfully?