vitor
07-09-2018, 09:12 AM
hi, friends. sorry for the poor english
what method would you use for a worksheet that would need to "get" screen data?
I'm using a macro that copies data from a spreadsheet and plays on the screen of another program (java form): sendkeys, but at some point, this java screen will present an information (code) that I need to use to continue the macro.
but how to store this information?
I need the code to copy this string that is in another open window and paste it into a cell in the worksheet
what method would you use for a worksheet that would need to "get" screen data?
I'm using a macro that copies data from a spreadsheet and plays on the screen of another program (java form): sendkeys, but at some point, this java screen will present an information (code) that I need to use to continue the macro.
but how to store this information?
I need the code to copy this string that is in another open window and paste it into a cell in the worksheet