Open IP address device with multi ports, read only

[TomR]

I need to Open an IP device with 24 sub ports.
I tried ADDCONNECTION, OPEN, etc. I cannot get these commands to
work.

Need to open an IP address 143.xxx.xxx.xxx sub port 2300 read_only.

If this is possible, I need to open another port on the same device,
but port 2400.
Then probably use an Event when data is available on either port....
TIA

 

[Patrick Molloy]

what is the device? do you have the correct connection string for it?

 

[TomR]

what is the device? do you have the correct connection string for it?








- Show quoted text -

Patrick,
Its a xyplex telecom device that has an IP address 143.96.xxx.xxx.
Each device has 24 ports and I need to access (2) ports (i.e. 2300 and
2400 - 2300 is input data and 2400 is output data).
We use the HYPERTERMINAL program currently and open both ports then
display the data on one screen.
Get confusing to see the data flow by and would like to try EXCEL and
manage the data by placing it in a cell.

I can PING the device, just cannot open it using the code
(ADDCONNECTION, OPEN, etc) I have for other apps.
Tom

 

[Patrick Molloy]

I don't think you can connect directly.

An alternative would be for your HyperTerminal to dump a text file and have
excel pick it up.
Dumping a text file is part of the HyperTerminal methods

 

[TomR]

I don't think you can connect directly.

An alternative would be for your HyperTerminal to dump a text file and have
excel pick it up.
Dumping a text file is part of the HyperTerminal methods








- Show quoted text -

I have pieces of WINSOCK code that I have tried and that also fails.
But how does HYPERTerminal attach to that port?. Can FTP possibly
work or start HyperTerminal in Excel and provide the prompts to
capture the data. Have not tried this before and would probably have
difficulties with the data just streaming by and being able to capture
it in real-time. Any other thoughts or from some of the MVP
folks....
Tom

 

[Patrick Molloy]

Hyper Terminal is an application as is Excel, and is not part of excel
However, in Excel vba you can start the application using the SHELL command
you need to set up Hyper Terminal so that it outputs text files
You then need to code excel so that it reads those files.
As for real time, I'm sure that this could be done in Excel using DDE, but I
have no experience of it I'm afraid.

========================================================

I have pieces of WINSOCK code that I have tried and that also fails.
But how does HYPERTerminal attach to that port?. Can FTP possibly
work or start HyperTerminal in Excel and provide the prompts to
capture the data. Have not tried this before and would probably have
difficulties with the data just streaming by and being able to capture
it in real-time. Any other thoughts or from some of the MVP
folks....
Tom

======================================================