Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
shared workbook is set up is not 'shared' on network | Excel Worksheet Functions | |||
shared workbook - shared workbook options grayed out | Excel Discussion (Misc queries) | |||
Shared Workbook - Slow opening of shared workbook. | Excel Programming | |||
Printing viewing a shared workbook on a shared drive | Excel Discussion (Misc queries) | |||
update pivot in shared shared workbook | Excel Discussion (Misc queries) |