VBA- Extract a field value from a screen
I am a novice in VBA and im trying to extract a field from a mainframe screen and write it onto an excel.
for this i used the copyscrn function to take a screenprint and then did a gettext for the object.
The field that im looking to extract is in the middle of the object and my question falls here.
For example if my screen looks like this:
Name: John ************: M Status: 0
Edu: Masters Attempts: 2 College: ABC Univ
Address: 12334 x ave. CITY: BARNES COUNTRY: HSGDFH
TESTS: PAID: STATUS:
How will i extract the value "HSGDFH" and then write it onto a cell say A1 in an excel.
Like u see, there are no field values after the COUNTRY field...
I've just ended up at a stop trying to copy that value back to the excel.
Appreciate any help on this!
Last edited by worstcasegemini; October 22nd, 2010 at 05:42 AM..