ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Open IP address device with multi ports, read only (https://www.excelbanter.com/excel-programming/431016-open-ip-address-device-multi-ports-read-only.html)

TomR[_2_]

Open IP address device with multi ports, read only
 
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

Open IP address device with multi ports, read only
 
what is the device? do you have the correct connection string for it?

"TomR" wrote in message
...
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


TomR[_2_]

Open IP address device with multi ports, read only
 
On Jul 13, 5:10*am, "Patrick Molloy"
wrote:
what is the device? do you have the correct connection string for it?

"TomR" wrote in message

...



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- Hide quoted text -


- 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

Open IP address device with multi ports, read only
 
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" wrote in message
...
On Jul 13, 5:10 am, "Patrick Molloy"
wrote:
what is the device? do you have the correct connection string for it?

"TomR" wrote in message

...



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- Hide quoted text -


- 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


TomR[_2_]

Open IP address device with multi ports, read only
 
On Jul 13, 9:59*am, "Patrick Molloy"
wrote:
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" wrote in message

...



On Jul 13, 5:10 am, "Patrick Molloy"
wrote:
what is the device? do you have the correct connection string for it?


"TomR" wrote in message


....


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- Hide quoted text -


- 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- Hide quoted text -


- 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


All times are GMT +1. The time now is 01:46 PM.

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