Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
Are you talking about putting a spreadsheet on a network drive that can be accessed by two different computers? If so, only one user can have Write access to the file, so if you try to send information to another book that is open on another computer you cannot save the book and also, the other user wont know you have added / tried to add more information. If you really want excel to work this way, you would have put the information in your book and SAVE it. The other book would then have to have a update button that can be pressed to check your book for new entries, and then write them to there book. Your book would then also need an update button to see if they accepted it Thats one the simplest way of doing something like that i suppose -- Anthony Prescott http://www.apofficesolutions.co.uk Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200812/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Comparing information on 2 worksheets | Excel Discussion (Misc queries) | |||
VBA passing information between differnt User Forms | Excel Programming | |||
gathering information from many worksheets | Excel Discussion (Misc queries) | |||
VBA Passing information from one worksheet to many others | Excel Programming | |||
Passing information from VBA variable to Excel range | Excel Programming |