ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   link to a workbook on another computer in lan (https://www.excelbanter.com/excel-programming/423465-link-workbook-another-computer-lan.html)

pls123

link to a workbook on another computer in lan
 
hi all!!
do you think it is possible to link in vbe or worksheet function,
to a workbook on another computer in lan ??

can you show me how ??
ty !!

Simon Lloyd[_1018_]

link to a workbook on another computer in lan
 

I don't understand what it is you are trying to do, you can have linked
workbooks, or you can store the workbook on a network drive which will
be accessible by both computers or you can set up file sharing if there
are just the two of you.

pls123;214582 Wrote:
hi all!!
do you think it is possible to link in vbe or worksheet function,
to a workbook on another computer in lan ??

can you show me how ??
ty !!



--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=58916


pls123

link to a workbook on another computer in lan
 
yes..i need linked workbook !!
do you think that will work in real time ??




"Simon Lloyd" wrote:


I don't understand what it is you are trying to do, you can have linked
workbooks, or you can store the workbook on a network drive which will
be accessible by both computers or you can set up file sharing if there
are just the two of you.

pls123;214582 Wrote:
hi all!!
do you think it is possible to link in vbe or worksheet function,
to a workbook on another computer in lan ??

can you show me how ??
ty !!



--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=58916



Simon Lloyd[_1020_]

link to a workbook on another computer in lan
 

I don't think so, i think you would have to have apage refresh that much
for it to look like real time that you wouldn't be able to enter data in
it, besides you link one workbook to the other not link them to each
other where data entered in both appears in both, it's normally from a
"Master" to a "Slave"
pls123;214975 Wrote:
yes..i need linked workbook !!
do you think that will work in real time ??




"Simon Lloyd" wrote:


I don't understand what it is you are trying to do, you can have

linked
workbooks, or you can store the workbook on a network drive which

will
be accessible by both computers or you can set up file sharing if

there
are just the two of you.

pls123;214582 Wrote:
hi all!!
do you think it is possible to link in vbe or worksheet function,
to a workbook on another computer in lan ??

can you show me how ??
ty !!



--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' ('The Code Cage' (http://www.thecodecage.com))

------------------------------------------------------------------------
Simon Lloyd's Profile: 'The Code Cage Forums - View Profile: Simon

Lloyd' (http://www.thecodecage.com/forumz/member.php?userid=1)
View this thread: 'link to a workbook on another computer in lan -

The Code Cage Forums'
(http://www.thecodecage.com/forumz/sh...ad.php?t=58916)




--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=58916



All times are GMT +1. The time now is 02:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com