var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: run program from cell and pass parameters
whilst searching your forum I found the answer to the first issue i had - ie run an external program (terminal emulator) by clicking on cell within excel spreadsheet using the worksheet code
my spreadsheet contains (300+) ip addresses, userids and passwords in columns 1,2,3
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column = 1 And Target.Count = 1 And Target.Value <> "" Then Shell "terminal emulator program -ssh " & Target.Value
I would like to pass the userid/password to the external program.
is this possible?
I have found that using command line parameters I can pass userid/password
ie term.exe -ssh -l userid -pw password
how can I code the command line above to use values as such from excell '-l (column3) -pw (column4)'