Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel:VBA. Copy data from one computer to another over LAN?

Status
Not open for further replies.

Roy1234

Programmer
Jun 22, 2007
1
US
I have an Excel application (Named RawData) running on one computer (Named Desktop). I would like to copy values from "Worksheets("Data").Range(A1:D20).Value" to another computer (Named Laptop) running an identical application with the same names. I would like to program this into a module using VBA but I cannot figure out the syntax. Both machines communicate over the network but I'm not sure this can be done with VBA.

Thanks

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top