I have an Excel application (Named RawData) running on one computer (Named Desktop). I would like to copy values from "Worksheets("Data").Range(A1
20).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
Thanks