Embed telnet command in excel cell

**farcry80** · 06-02-2009, 03:34 PM

Hi all,
I am an excel newbie and I wanted to do something relatively simple. I have a server name in an excel field and I want to be able to double click that field and have excel run the telnet command and get me to the server's login prompt.

Thanks all.

**Paul** · 06-02-2009, 10:29 PM

Hi Farcry80, and welcome to the forum.

This may work for you..

Let's assume your 'excel field' is cell A1. Right-click on the worksheet tab with the server name in A1 and choose 'View Code'. Paste the following code into the VB Editor window, then close that window.

Double-click on A1 and see if it works!

Please Login or Register  to view this content.

If your server name is not in cell A1, change that reference in the code to your actual cell address.

**farcry80** · 06-03-2009, 09:26 AM

Paul,
Thanks so much for your effort and eureka it worked.!!!

I just had another query. Is there anyway for the telnet window when excuted to come on top of the excel spreadsheet so I dont have to alt-tab, to get to it?

Again thanks a bunch and please let me know how I can rate you.

**lilmouse** · 09-28-2009, 01:39 PM

This script was very useful to me as well but am in need of additional help. When I telnet I must enter my username and password and need to run a show inv and show snmp command as well. how would i put this in the script to run the telnet and input my un, pass, and the two commands?

**Paul** · 09-28-2009, 06:12 PM

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.

**Paul** · 09-13-2013, 12:17 PM

Update for Windows 7 users:

By default, the Telnet client is not installed in Windows 7. You can install the client easily (see here: http://technet.microsoft.com/en-us/l...(v=ws.10).aspx).

Once you do this, you should be able to use the code shown in my previous post. (Tested on my Win7 machine and confirmed.)