Over a Network 1

[shavenlunatic]

Hi,

I fear this may be slightly stressing the limitations of excel/vba .. BUT, im curious

Basically, I was wondering if there is a fairly sensible way ofnsending information over a network. I've tried searching on this but due to the nature of what I'm looking for, its difficult to find anything that remotely resembles what I want.

To give an example of what I am looking to do (although this is not exactly what I want to to but carries the same principles) I would like to have a form open in excel on one computer(A), type some text in a text box then hit a submit button.. Meanwhile computer(B) has an excel form open witha blank textbox, sitting there doing nothing... when computer A hits submit, computer B's textbox populates with said information.

As I said, I'm not actually looking to make a "chat/messenger" program for excel, but the basic construct would allow values such as text to be passed over.

I doubt it's possible without some pretty random stuff going on but hey.. if ya don't ask

________
clueless

 

[Andrzejek]

They way I see it:

You have a database sitting somewhere on the network
A writes data into the table in db
B is looking at this table (every 1 sec?) and if finds new info in the table - BINGO!



Have fun.

---- Andy

 

[shavenlunatic]

ah, not a bad idea.. thinking outside the box and all that

thank you that man, i will have a play

________
clueless

 

[shavenlunatic]

incidentally...the database idea is great and I expect I will be running with something along those lines.. but I am mildly curious if it is possible to transmit data on a client-client basis using vba functions..

________
clueless