Extract multiple data from AttachMate with account # in excel

[Biznez]

Hello everyone, im new at this and i like some help extracting data from Attachmate. So basically i have an account # in excel in cell "I2". When i press the extract button, in mainframe from T750 screen, it automatically enters the account # and moves to another screeen. From this screen at point 4, 12, i enter the number 2 and enter next screen enter #8 from 6, 2 and hit enter. On this final screen i have payments the customer made. I would like to extract these payments and dates.
I have this code below so far. Help would be greatly appreciated. Thanks

' Global variable declarations
Global g_HostSettleTime%
Global g_szPassword$

Sub Main()
'--------------------------------------------------------------------------------
' Get the main system object
	Dim Sessions As Object
	Dim System As Object
	Set System = CreateObject("EXTRA.System")	' Gets the system object
	If (System is Nothing) Then
		Msgbox "Could not create the EXTRA System object.  Stopping macro playback."
		STOP
	End If
	Set Sessions = System.Sessions

	If (Sessions is Nothing) Then
		Msgbox "Could not create the Sessions collection object.  Stopping macro playback."
		STOP
	End If
'--------------------------------------------------------------------------------
' Set the default wait timeout value
	g_HostSettleTime = 75		' milliseconds

	OldSystemTimeout& = System.TimeoutValue
	If (g_HostSettleTime > OldSystemTimeout) Then
		System.TimeoutValue = g_HostSettleTime
	End If

' Get the necessary Session Object
	Dim Sess0 As Object
	Set Sess0 = System.ActiveSession
	If (Sess0 is Nothing) Then
		Msgbox "Could not create the Session object.  Stopping macro playback."
		STOP
	End If
	If Not Sess0.Visible Then Sess0.Visible = TRUE
	Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
	
' This section of code contains the recorded events
	Sess0.Screen.Sendkeys("123456789<Enter>")	
	Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
	Sess0.Screen.Sendkeys("<Home>2<Enter>")	
	Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
	Sess0.Screen.Sendkeys("<Home>8<Enter>")	
	Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
	Sess0.Screen.Sendkeys("<Pf7>")	
	Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
	Sess0.Screen.Sendkeys("<Pf7>")	
	Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
	Sess0.Screen.Sendkeys("<Pf7>")	
	Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
	Sess0.Screen.Sendkeys("<Pf7>")	
	Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
	Sess0.Screen.Sendkeys("<Pf7>")	
	Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
	Sess0.Screen.Sendkeys("<Pf7>")	
	Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
	Sess0.Screen.Sendkeys("<Pf7>")	
	Sess0.Screen.WaitHostQuiet(g_HostSettleTime)

	System.TimeoutValue = OldSystemTimeout
End Sub

 

[Biznez]

In addition, all this data would extract to excel spreadsheet

 

[SkipVought]

Hi,

The next thing you must establish is the screen navigation logic. You need to document and include in you logic, for each screen, the SUCESSFUL result MESSAGE, the THERE'S MORE MESSAGE, and ALL the EXCEPTION MESSAGES and the WHAT TO DO NEXT for each of these conditions. All this logic must be coded BEFORE you think about your Excel read/write loop.