Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old October 22nd, 2010, 05:39 AM
Registered User
Join Date: Oct 2010
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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

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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Setting a form's field with VBA! mzu_cold Access VBA 6 September 18th, 2009 09:26 AM
Extract data from memo field knix2007 Access VBA 7 December 17th, 2007 03:24 PM
Extract part of field from inconsistent data Roly Reefer Access VBA 4 March 31st, 2005 09:25 AM
inserting worksheet into an OLE field with VBA Mihai B Excel VBA 2 January 21st, 2005 06:50 AM
Extract Field Value maha Access 2 June 25th, 2003 12:05 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.