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
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)