using com port in xcel vba
using com port in xcel vba
(OP)
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
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





RE: using com port in xcel vba
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
RE: using com port in xcel vba
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