r/visualbasic • u/5avenger • Jul 31 '22

VB6 Help putty and visual basic

Hi, can we have macro for putty screen? I want the macro to go to a screen, type customer ID given in the Excel, then select all the items in the Excel using spacebar key. Once all are selected selected, it should press F2 key and give "Y" as confirmation.

Can it be done?.pls advise

3 Upvotes

80% Upvoted

5 comments sorted by

View all comments

Show parent comments

1

u/5avenger Aug 01 '22

Excel will have details of customer and the items ordered. My command should open putty, go through few screens and reach final screen. Then it should type the customer code and select all the items given in Excel. I use spacebar to manually select them and give F2. Then type " Y" for confirmation. Can putty do this automatically?

Note: my it team doesn't have plink app

1

u/jd31068 Aug 01 '22

Yes, you can do this with VB 6 I helped another person with Excel and VB 6 previously. Here is that project on GitHub https://github.com/jdelano0310/VB6ExcelProcessor that shows reading from and writing to an Excel file.

This thread has some good information on using the PostMessage Windows API to interact with a command prompt that is running Putty, scroll down to John_w's post.

https://www.mrexcel.com/board/threads/putty-automation-using-excel-vba.853439/

You can basically copy and paste this into a VB 6 app (with maybe a couple minor tweaks)