using com port in xcel vba 2

[don01]

hi all
I am searching for a clue. I have a protocol to interigate a plc via a serial link.
I can prepare the strings and open the com port in turbo basic and get the reply string etc etc.
So the next step was to do this direct from the xcel sheet. And here it all falls over. I can Open com1: 9600,8,1, etc etc and this is ok but now I would normally print #1 message$ , then delay then read #1 but xcell really hates me trying to write, print, put, to any thing related to the com port.
I am using the same port as turbo basic and com set up values but I get syntax errors (not time out type problems).
has any one had any luck doing this if so, how?
Any clues greatly appreciated
thanks Don

 

[ivymike]

I've been pondering the same problem recently. I haven't tested this method yet, but it looks promising:

http://www.taltech.com/TALtech_web/support/dde_sw/ddeexcel501.htm

this may also be helpful:

http://www.mediacy.com/tech/ipuml/2001/msg00069.html

or pages 6&7 of this:

http://www.milltronics.com/pdf/app_guide/99007-2.pdf

 

[don01]

hi ivymike
heaps o thanks there. It's really late tonight but I'll hit those sites tommorrow straight after work.
again your response appreciated
& will advise results
Don