Macro to open Putty and paste contents

i,

I'm new to excel macro, and I have this big requirement to complete..

Requirement:

1. Connect to putty through excel macro - the login details should betaken from cells in excel.
2. Run few commands in putty - these commands also will be added in the excel macro.
3. Results of the commands needs to be displayed in the excel.

I have this below but it opens when i double click the device name in the cell.

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    Shell "C:\Users\mohiibrahim\Desktop\putty.exe -ssh -l a-username" & ActiveCell, 1
    Cancel = True
End Sub

Drawbacks in this is it is not taking the the password from cells in excel and not displaying the output in excel


Basically, on click of a button, it should get connected to putty and run the commands and results should be displayed.

Any other solution also accepted

Any help would be appreciated...!!!

Thanks,

I'd recommend using plink. It's commandline interface to the PuTTY back ends, and easier to work with. PuTTY is more of interactive GUI.

Documentation for plink:
https://the.earth.li/~sgtatham/putty.../Chapter7.html

Sample Code attached: "hello, world" where A1 holds username and B1 holds password.

Otherwise try following example in link for PuTTY (by John_w)
https://www.mrexcel.com/forum/excel-...excel-vba.html

Edit: If you want pline returned to Excel. You'll need to add counter and use that as row index for range that you want to put the value into.

Hi I have this.but when ever i save this code and double click where ever in the sheet it tries to open the Putty ssh with the value in the cell.
But what i require is like only

1. A2:A16 these ranges if we double click it open ssh with Putty . Anywhere else if we double click it should not open putty
2. For Password it should take from the value in cell A1 because everyday we get new password so i paste the password in the A1. Username is constant so no issues
Can some one help to achieve above by editing the below script
================================================================

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    Shell "C:\Users\username\Desktop\putty.exe -ssh -l a-username" & ActiveCell, 1
    Cancel = True
End Sub

================================================================

@imabbas_90

Code Tags Added
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE] [/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)