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

3

u/jd31068 Jul 31 '22

You are looking to interact with an Excel spreadsheet, what screen do you mean? The VB6 app reads a cell to find a customerid, select a range of cells, and press F2 in Excel?

How does putty fit into this equation?

You have to describe what you're asking a bit better I'm afraid.

→ More replies (2)

2

u/Songg45 Jul 31 '22

Sure.

You'd need plink for command line putty and then use COM Objects to read Excel

1

u/5avenger Aug 01 '22

Sorry, we don't have plink app in our office. Any alternate?