Shared workbook for Writing
 

1) What is the best method with Excel 2003 and Excel 2007 for sharing a
workbook and leting multiple users write file through 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?