|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 15th, 2006, 02:29 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
column redirect
I have a spreadsheet that has a coulmn of ip addresses. I want to know if
there is a way to config this column so that when I click on a particular ip address in a cell, I will be able to telnet to that Ip address...is this possible? 
|
|
#2
September 15th, 2006, 02:47 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
column redirect
How about a formula like:
=HYPERLINK("telnet:\\"&A1) (with A1 containing the ip address. Then drag down the column.) (It opened up a telnet window in my test.) kjs wrote: I have a spreadsheet that has a coulmn of ip addresses. I want to know if there is a way to config this column so that when I click on a particular ip address in a cell, I will be able to telnet to that Ip address...is this possible? -- Dave Peterson
|
|
#3
September 15th, 2006, 03:13 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
column redirect
I'm a novice at this...how do i get this working?
"Dave Peterson" wrote: How about a formula like: =HYPERLINK("telnet:\\"&A1) (with A1 containing the ip address. Then drag down the column.) (It opened up a telnet window in my test.) kjs wrote: I have a spreadsheet that has a coulmn of ip addresses. I want to know if there is a way to config this column so that when I click on a particular ip address in a cell, I will be able to telnet to that Ip address...is this possible? -- Dave Peterson
|
|
#4
September 15th, 2006, 06:06 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
column redirect
What is the address of the top cell containing the ip address?
Say it's A1. Then insert a new column B. Then put this in B1. =HYPERLINK("telnet:\\"&A1) Test it to see if it works by clicking on the resulting hyperlink. If it does, then use the techniques described by Debra Dalgleish: http://www.contextures.com/xlDataEntry01.html to fill the cells underneath that first cell with the formula. kjs wrote: I'm a novice at this...how do i get this working? "Dave Peterson" wrote: How about a formula like: =HYPERLINK("telnet:\\"&A1) (with A1 containing the ip address. Then drag down the column.) (It opened up a telnet window in my test.) kjs wrote: I have a spreadsheet that has a coulmn of ip addresses. I want to know if there is a way to config this column so that when I click on a particular ip address in a cell, I will be able to telnet to that Ip address...is this possible? -- Dave Peterson -- Dave Peterson
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
