Is it possible at all to send EXCEL data within a network?

R

Rafael

.... if EXCEL is working on PC1 and PC2 separatly, opend with differen
workbooks. And I don't mean just to open a working copy o
PC1-EXCEL-Workbook on PC2 or the other way around. Nor do I mean
function e.g. similar =\\PC1\EXCEL|[Workbooks.xls]Sheets1!'Z1S1' of
single cell, where the values should be updated automatically.

Actually I am intending to send data via code (workbook opend) from on
PC to another within the network. Because it works on a single PC wit
EXCEL opened twice separatly, or it works as data transfer from EXCE
to a data base. So it should work within a network as well, shouldn'
it?



That's the code example in which EXCEL is opened twice separatly on on
PC:

Range(Sheets(1).Cells(8, 4), Sheets(1).Cells(28
12)).SpecialCells(xlCellTypeVisible).Copy _
Workbooks("DataLog").Sheets(2).Cells(1,1) .... With that I can easil
copy data from one Workbook to another on the s a m e PC.


But how do I have to modify the code to manage the same thing, but fro
one PC to the other?

??

Range(Sheets(1).Cells(8, 4), Sheets(1).Cells(28
12)).SpecialCells(xlCellTypeVisible).Copy _
\\Hnpc2\C:\Archiv\DataLog\ ......Sheets(2).Cells(1, 1)


??

I am grateful for each advice and thank you in anticipation

Rafae
 
Top