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,