Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2012

    Question 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

    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
    End Sub
    my spreadsheet contains (300+) ip addresses, userids and passwords in columns 1,2,3

    I would like to pass the userid/password to the external program.

    is this possible?

  2. #2
    Join Date
    Feb 2012
    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)'

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts