Submit data of a form of excel sheet on main pc on LAN.

December 29, 2011 at 02:12:43
Specs: Windows XP
Hi guys
Please tell me how to create a button in excel sheet to send specific cells (entries) to other PC on network. Suppose we have a form in excel format on reception PC which has name, age, address fields. we fill them and press submit button to send these fields to other PC on network.

thanks


See More: Submit data of a form of excel sheet on main pc on LAN.

Report •


#1
December 29, 2011 at 06:52:57
You can't "send" specific cells to another PC or even another file.

You can send the entire file or you can use a macro to modify an existing file on the other PC, but you can't "send" cells.

Why not just create links from one workbook to another so that when cells are changed on the Reception PC the linked cells would also update on the other PC?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question