View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Crowbar via OfficeKB.com Crowbar via OfficeKB.com is offline
external usenet poster
 
Posts: 128
Default Passing information between worksheets

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