Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Attachmate Macro Help, hopefully the last. :) "Procedure Too Large"

Status
Not open for further replies.
afortuna98

afortuna98

Programmer
Apr 4, 2014
28
US
So, I thought I was done. With Skip's help, I was able to get past having the macro check an Excel value, then operate within Attachmate accordingly. My current problem "Procedure Too Large." I'll post the entire macro in this thread (a little over 1200 lines). My skills are very limited, but I'm trying. The macro in function works fine with the exception of the above message. The macro does two things for us, grabs info regarding a permit or license to post into an Excel Spreadsheet and then grabs info related to who owns that permit or license and also enters it into the same Excel Spreadsheet.

The ownership section, which starts on line 201 "Begin Dialog cbdlg 99, 130, 185, 130, "PACKAGE TYPE". It is broken into three sections based on the option they choose on the created check box (Sole Proprietor, Partnership, Corporation). Each of the individual sections work as intended within the macro. If I take out the Corporation macro lines, then it is the correct size and works fine for Partnerships. If I take out the Partnership section of the macro leaving all other sections in place, then the corporation section works fine. I basically have too many lines and dont' know what to do about it. What would you believe to be the easiest way to overcome the "Procedure Too Large" issue? I don't know how to add subs and there doesn't seem to be an internet spot with clear instructions or examples. I attempted to split the second half into it's own macro, then do a macro that runs two macros, but had error issues come up that I didn't understand as to why they were issues. I'm sorry if it is not indented.

'--------------------------------------------------------------------------------
' This macro was created by
' Date: April 2, 2014
' User: afortuna
'--------------------------------------------------------------------------------

' 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 = 500 ' 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 script

Dim obj as object
Dim objWorkbook as object
Set obj = CreateObject("Excel.Application")
obj.Workbooks.Open FileName:="C:\Users\AFortuna\Documents\Investigations\Inspections\Macro Files\Tester.xlsx" 'File location If the file is not already open
' Set obj = Getobject("C:\Users\AFortuna\Documents\Investigations\Inspections\Macro Files\Tester.xlsx") 'File is already open
obj.visible = True 'Not used if file is already open

Sess0.Screen.Sendkeys("<PF3><PF3><PF3>")
Pause 2
Sess0.Screen.Putstring "TAR", 21, 5
Sess0.Screen.Putstring "AI", 21, 9
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop

Sess0.Screen.MoveTo 21,12
MsgBox "ENTER CTPL"
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop

Sess0.Screen.WaitForCursor 21,21
Sess0.Screen.Sendkeys("<Enter>")
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop

Location = Trim(Sess0.Screen.GetString (04,09,4))
If Location = "FLAG" Then
Sess0.Screen.Sendkeys("<PF3><PF3>")
Pause 2
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop
End IF

obj.WorkSheets("Data Input").Cells(1, "A").Value = sess0.Screen.GetString(13, 48, 3) 'Phone # Area
obj.WorkSheets("Data Input").Cells(2, "A").Value = sess0.Screen.GetString(13, 52, 3) 'Phone # Prefix
obj.WorkSheets("Data Input").Cells(3, "A").Value = sess0.Screen.GetString(13, 56, 4) 'Phone # Postfix
obj.WorkSheets("Data Input").Cells(4, "A").Value = sess0.Screen.GetString(4, 65, 3) 'License Part 1
obj.WorkSheets("Data Input").Cells(5, "A").Value = sess0.Screen.GetString(4, 69, 6) 'License Part 2
obj.WorkSheets("Data Input").Cells(6, "A").Value = sess0.Screen.GetString(10, 15, 50) 'DBA
obj.WorkSheets("Data Input").Cells(7, "A").Value = sess0.Screen.GetString(11, 20, 41) 'Business Street
obj.WorkSheets("Data Input").Cells(8, "A").Value = sess0.Screen.GetString(12, 20, 30) 'Business City
obj.WorkSheets("Data Input").Cells(9, "A").Value = sess0.Screen.GetString(12, 55, 2) 'Business State
obj.WorkSheets("Data Input").Cells(10, "A").Value = sess0.Screen.GetString(12, 63, 5) 'Business Zip
obj.WorkSheets("Data Input").Cells(11, "A").Value = sess0.Screen.GetString(18, 24, 3) 'SR Part 1
obj.WorkSheets("Data Input").Cells(12, "A").Value = sess0.Screen.GetString(18, 27, 6) 'SR Part 2
obj.WorkSheets("Data Input").Cells(13, "A").Value = sess0.Screen.GetString(18, 33, 5) 'SR Sublocation
obj.WorkSheets("Data Input").Cells(14, "A").Value = sess0.Screen.GetString(7, 15, 2) 'CTPL Start Date Month
obj.WorkSheets("Data Input").Cells(15, "A").Value = sess0.Screen.GetString(7, 18, 2) 'CTPL Start Date Day
obj.WorkSheets("Data Input").Cells(16, "A").Value = sess0.Screen.GetString(7, 21, 2) 'CTPL Start Date Year
obj.WorkSheets("Data Input").Cells(17, "A").Value = sess0.Screen.GetString(20, 39, 2) 'CTPL C/O Month
obj.WorkSheets("Data Input").Cells(18, "A").Value = sess0.Screen.GetString(20, 42, 2) 'CTPL C/O Day
obj.WorkSheets("Data Input").Cells(19, "A").Value = sess0.Screen.GetString(20, 45, 2) 'CTPL C/O Year
obj.WorkSheets("Data Input").Cells(20, "A").Value = sess0.Screen.GetString(9, 78, 1) 'Owner Code

Dim Sys As Object, Sess As Object, MyScreen As Object, MyArea As Object

Set Sys = CreateObject("EXTRA.System")
Set Sess = Sys.ActiveSession
Set MyScreen = Sess.Screen
Set MyArea = MyScreen.Area(18, 24, 18, 32)
MyArea.Select
MyScreen.Copy

Sess0.Screen.Putstring "TAR", 21, 5
Sess0.Screen.Putstring "AI", 21, 9
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop

Sess0.Screen.MoveTo 21,12
Sess0.Screen.Paste
Sess0.Screen.Sendkeys("<Enter>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop

Location = Trim(Sess0.Screen.GetString (04,09,4))
If Location = "FLAG" Then
Sess0.Screen.Sendkeys("<PF3>")
Pause 2
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop
End IF

obj.WorkSheets("Data Input").Cells(21, "A").Value = sess0.Screen.GetString(4, 38, 3) 'TAT
obj.WorkSheets("Data Input").Cells(22, "A").Value = sess0.Screen.GetString(4, 55, 3) 'District
obj.WorkSheets("Data Input").Cells(23, "A").Value = sess0.Screen.GetString(16, 17, 53) 'Mailing Street
obj.WorkSheets("Data Input").Cells(24, "A").Value = sess0.Screen.GetString(17, 17, 30) 'Mailing City
obj.WorkSheets("Data Input").Cells(25, "A").Value = sess0.Screen.GetString(17, 52, 2) 'Mailing State
obj.WorkSheets("Data Input").Cells(26, "A").Value = sess0.Screen.GetString(17, 60, 5) 'Mailing Zip
obj.WorkSheets("Data Input").Cells(27, "A").Value = sess0.Screen.GetString(14, 17, 2) 'County Code
obj.WorkSheets("Data Input").Cells(28, "A").Value = sess0.Screen.GetString(7, 15, 2) 'Start Date Month
obj.WorkSheets("Data Input").Cells(29, "A").Value = sess0.Screen.GetString(7, 18, 2) 'Start Date Day
obj.WorkSheets("Data Input").Cells(30, "A").Value = sess0.Screen.GetString(7, 21, 2) 'Start Date Year
obj.WorkSheets("Data Input").Cells(31, "A").Value = sess0.Screen.GetString(8, 17, 2) 'SR C/O Month
obj.WorkSheets("Data Input").Cells(32, "A").Value = sess0.Screen.GetString(8, 20, 2) 'SR C/O Day
obj.WorkSheets("Data Input").Cells(33, "A").Value = sess0.Screen.GetString(8, 23, 2) 'SR C/O Year
obj.WorkSheets("Data Input").Cells(34, "A").Value = sess0.Screen.GetString(12, 62, 3) 'SR Phone
obj.WorkSheets("Data Input").Cells(35, "A").Value = sess0.Screen.GetString(12, 66, 3) 'SR Phone
obj.WorkSheets("Data Input").Cells(36, "A").Value = sess0.Screen.GetString(12, 70, 4) 'SR Phone
obj.WorkSheets("Data Input").Cells(37, "A").Value = sess0.Screen.GetString(11, 14, 40) 'SR DBA


IF obj.WorkSheets("Data Input").Cells(13, "A").Value > 0 Then
obj.WorkSheets("Data Input").Cells(13, "A").copy
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.MoveTo 4,76
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.paste
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("<Enter>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop

Location = Trim(Sess0.Screen.GetString (04,09,4))
If Location = "FLAG" Then
Sess0.Screen.Sendkeys("<PF3>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop
End IF

obj.WorkSheets("Data Input").Cells(38, "A").Value = sess0.Screen.GetString(6, 73, 2) 'Sub Start Date Month
obj.WorkSheets("Data Input").Cells(39, "A").Value = sess0.Screen.GetString(6, 76, 2) 'Sub Start Date Day
obj.WorkSheets("Data Input").Cells(40, "A").Value = sess0.Screen.GetString(6, 79, 2) 'Sub Start Date Year
obj.WorkSheets("Data Input").Cells(41, "A").Value = sess0.Screen.GetString(7, 73, 2) 'Sub C/O Month
obj.WorkSheets("Data Input").Cells(42, "A").Value = sess0.Screen.GetString(7, 76, 2) 'Sub C/O Day
obj.WorkSheets("Data Input").Cells(43, "A").Value = sess0.Screen.GetString(7, 79, 2) 'Sub C/O Year
obj.WorkSheets("Data Input").Cells(44, "A").Value = sess0.Screen.GetString(10, 11, 40) 'Sub DBA
obj.WorkSheets("Data Input").Cells(45, "A").Value = sess0.Screen.GetString(12, 63, 3) 'Sub Phone
obj.WorkSheets("Data Input").Cells(46, "A").Value = sess0.Screen.GetString(12, 67, 3) 'Sub Phone
obj.WorkSheets("Data Input").Cells(47, "A").Value = sess0.Screen.GetString(12, 71, 4) 'Sub Phone


Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.MoveTo 4,24
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("<EraseEOF>")
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.SendKeys ("<Enter>")
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop
END IF

Begin Dialog cbdlg 99, 130, 185, 130, "PACKAGE TYPE"
ButtonGroup .bg
OkButton 131, 74, 50, 14
CancelButton 132, 109, 50, 14
CheckBox 2, 0, 40, 10, "SOLE", .CheckBox1
CheckBox 2, 18, 40, 10, "PART", .CheckBox2
CheckBox 2, 36, 40, 10, "CORP", .CheckBox3
Text 44, 01, 96, 8, "SOLE OWNER"
Text 44, 19, 96, 8, "PARTNERSHIP"
Text 44, 37, 96, 8, "CORPORATION"
Text 44, 54, 96, 8, "Please check a checkbox"
Text 45, 78, 76, 8, "And then click OK -->"
End Dialog

Dim my_dialog as cbdlg
On Error Resume Next
Dialog my_dialog
If Err=102 then
MsgBox "canceled."
End If

If my_dialog.CheckBox1 Then

Set Sys = CreateObject("EXTRA.System")
Set Sess = Sys.ActiveSession
Set MyScreen = Sess.Screen
Set MyArea = MyScreen.Area(4, 10, 4, 20)
MyArea.Select
MyScreen.Copy

Sess0.Screen.Putstring "CTS", 21, 5
Sess0.Screen.Putstring "CM", 21, 9
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop

Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.MoveTo 21,12
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Paste
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.SendKeys ("<Enter>")
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop

Location = Trim(Sess0.Screen.GetString (04,09,4))
If Location = "FLAG" Then
Pause 1
Sess0.Screen.Sendkeys("<PF3>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop
End IF

obj.WorkSheets("Data Input").Cells(1, "G").Value = sess0.Screen.GetString(4, 15, 8) 'Sole Prop Tin
obj.WorkSheets("Data Input").Cells(48, "A").Value = sess0.Screen.GetString(5, 27, 32) 'Sole Proprietor Name
obj.WorkSheets("Data Input").Cells(49, "A").Value = sess0.Screen.GetString(8, 10, 3) 'Sole Proprietor SSN
obj.WorkSheets("Data Input").Cells(50, "A").Value = sess0.Screen.GetString(8, 14, 2) 'Sole Proprietor SSN
obj.WorkSheets("Data Input").Cells(51, "A").Value = sess0.Screen.GetString(8, 17, 4) 'Sole Proprietor SSN
obj.WorkSheets("Data Input").Cells(52, "A").Value = sess0.Screen.GetString(8, 27, 2) 'Sole Proprietor DOB
obj.WorkSheets("Data Input").Cells(53, "A").Value = sess0.Screen.GetString(8, 30, 2) 'Sole Proprietor DOB
obj.WorkSheets("Data Input").Cells(54, "A").Value = sess0.Screen.GetString(8, 33, 4) 'Sole Proprietor DOB
obj.WorkSheets("Data Input").Cells(55, "A").Value = sess0.Screen.GetString(8, 50, 2) 'Sole Proprietor CDL ST
obj.WorkSheets("Data Input").Cells(56, "A").Value = sess0.Screen.GetString(8, 61, 8) 'Sole Proprietor CDL
obj.WorkSheets("Data Input").Cells(57, "A").Value = sess0.Screen.GetString(9, 10, 3) 'Sole Proprietor Phone
obj.WorkSheets("Data Input").Cells(58, "A").Value = sess0.Screen.GetString(9, 16, 3) 'Sole Proprietor Phone
obj.WorkSheets("Data Input").Cells(59, "A").Value = sess0.Screen.GetString(9, 22, 4) 'Sole Proprietor Phone
obj.WorkSheets("Data Input").Cells(60, "A").Value = sess0.Screen.GetString(9, 48, 3) 'Sole Proprietor Phone
obj.WorkSheets("Data Input").Cells(61, "A").Value = sess0.Screen.GetString(9, 54, 3) 'Sole Proprietor Phone
obj.WorkSheets("Data Input").Cells(62, "A").Value = sess0.Screen.GetString(9, 60, 4) 'Sole Proprietor Phone
obj.WorkSheets("Data Input").Cells(63, "A").Value = sess0.Screen.GetString(16, 17, 53) 'Sole Proprietor Street
obj.WorkSheets("Data Input").Cells(64, "A").Value = sess0.Screen.GetString(17, 17, 30) 'Sole Proprietor City
obj.WorkSheets("Data Input").Cells(65, "A").Value = sess0.Screen.GetString(17, 56, 2) 'Sole Proprietor State
obj.WorkSheets("Data Input").Cells(66, "A").Value = sess0.Screen.GetString(17, 64, 5) 'Sole Proprietor Zip
End IF

If my_dialog.CheckBox2 Then

Set Sys = CreateObject("EXTRA.System")
Set Sess = Sys.ActiveSession
Set MyScreen = Sess.Screen
Set MyArea = MyScreen.Area(4, 10, 4, 20)
MyArea.Select
MyScreen.Copy

Sess0.Screen.Putstring "CTS", 21, 5
Sess0.Screen.Putstring "CM", 21, 9
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop

Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.MoveTo 21,12
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Paste
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.SendKeys ("<Enter>")
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop

Location = Trim(Sess0.Screen.GetString (04,09,4))
If Location = "FLAG" Then
Pause 1
Sess0.Screen.Sendkeys("<PF3>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop
End IF

obj.WorkSheets("Data Input").Cells(2, "G").Value = sess0.Screen.GetString(5, 16, 11) 'Partnership Tin
obj.WorkSheets("Data Input").Cells(67, "A").Value = sess0.Screen.GetString(7, 25, 34) 'Partnership Name
obj.WorkSheets("Data Input").Cells(68, "A").Value = sess0.Screen.GetString(12, 10, 3) 'Partnership Phone
obj.WorkSheets("Data Input").Cells(69, "A").Value = sess0.Screen.GetString(12, 16, 3) 'Partnership Phone
obj.WorkSheets("Data Input").Cells(70, "A").Value = sess0.Screen.GetString(12, 22, 4) 'Partnership Phone
obj.WorkSheets("Data Input").Cells(71, "A").Value = sess0.Screen.GetString(16, 17, 51) 'Partnership Street
obj.WorkSheets("Data Input").Cells(72, "A").Value = sess0.Screen.GetString(17, 17, 31) 'Partnership City
obj.WorkSheets("Data Input").Cells(73, "A").Value = sess0.Screen.GetString(17, 56, 2) 'Partnership State
obj.WorkSheets("Data Input").Cells(74, "A").Value = sess0.Screen.GetString(17, 64, 5) 'Partnership Zip
Sess0.Screen.Sendkeys("<PF10>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop

obj.WorkSheets("Data Input").Cells(5, "I").Value = sess0.Screen.GetString(10, 70, 9) 'Tin 1
obj.WorkSheets("Data Input").Cells(6, "I").Value = sess0.Screen.GetString(11, 70, 9) 'Tin 2
obj.WorkSheets("Data Input").Cells(7, "I").Value = sess0.Screen.GetString(12, 70, 9) 'Tin 3
obj.WorkSheets("Data Input").Cells(8, "I").Value = sess0.Screen.GetString(13, 70, 9) 'Tin 4
obj.WorkSheets("Data Input").Cells(9, "I").Value = sess0.Screen.GetString(14, 70, 9) 'Tin 5
obj.WorkSheets("Data Input").Cells(10, "I").Value = sess0.Screen.GetString(15, 70, 9) 'Tin 6
obj.WorkSheets("Data Input").Cells(11, "I").Value = sess0.Screen.GetString(16, 70, 9) 'Tin 7
obj.WorkSheets("Data Input").Cells(75, "G").Value = sess0.Screen.GetString(10, 45, 8) 'Part End Date
obj.WorkSheets("Data Input").Cells(94, "G").Value = sess0.Screen.GetString(11, 45, 8) 'Part End Date
obj.WorkSheets("Data Input").Cells(113, "G").Value = sess0.Screen.GetString(12, 45, 8) 'Part End Date
obj.WorkSheets("Data Input").Cells(132, "G").Value = sess0.Screen.GetString(13, 45, 8) 'Part End Date
obj.WorkSheets("Data Input").Cells(151, "G").Value = sess0.Screen.GetString(14, 45, 8) 'Part End Date
obj.WorkSheets("Data Input").Cells(170, "G").Value = sess0.Screen.GetString(15, 45, 8) 'Part End Date
obj.WorkSheets("Data Input").Cells(189, "G").Value = sess0.Screen.GetString(16, 45, 8) 'Part End Date


IF obj.WorkSheets("Data Input").Cells(5, "I").Value > 0 Then
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.MoveTo 10,68
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("M")
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("<Enter>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop

Location = Trim(Sess0.Screen.GetString (04,09,4))
If Location = "FLAG" Then
Sess0.Screen.Sendkeys("<PF3>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop
End IF

obj.WorkSheets("Data Input").Cells(75, "A").Value = sess0.Screen.GetString(5, 27, 32) 'Partner 1 Name
obj.WorkSheets("Data Input").Cells(76, "A").Value = sess0.Screen.GetString(8, 10, 3) 'Partner 1 SSN
obj.WorkSheets("Data Input").Cells(77, "A").Value = sess0.Screen.GetString(8, 14, 2) 'Partner 1 SSN
obj.WorkSheets("Data Input").Cells(78, "A").Value = sess0.Screen.GetString(8, 17, 4) 'Partner 1 SSN
obj.WorkSheets("Data Input").Cells(79, "A").Value = sess0.Screen.GetString(8, 27, 2) 'Partner 1 DOB
obj.WorkSheets("Data Input").Cells(80, "A").Value = sess0.Screen.GetString(8, 30, 2) 'Partner 1 DOB
obj.WorkSheets("Data Input").Cells(81, "A").Value = sess0.Screen.GetString(8, 33, 4) 'Partner 1 DOB
obj.WorkSheets("Data Input").Cells(82, "A").Value = sess0.Screen.GetString(8, 50, 2) 'Partner 1 CDL ST
obj.WorkSheets("Data Input").Cells(83, "A").Value = sess0.Screen.GetString(8, 61, 8) 'Partner 1 CDL
obj.WorkSheets("Data Input").Cells(84, "A").Value = sess0.Screen.GetString(9, 10, 3) 'Partner 1 Phone
obj.WorkSheets("Data Input").Cells(85, "A").Value = sess0.Screen.GetString(9, 16, 3) 'Partner 1 Phone
obj.WorkSheets("Data Input").Cells(86, "A").Value = sess0.Screen.GetString(9, 22, 4) 'Partner 1 Phone
obj.WorkSheets("Data Input").Cells(87, "A").Value = sess0.Screen.GetString(9, 48, 3) 'Partner 1 Phone
obj.WorkSheets("Data Input").Cells(88, "A").Value = sess0.Screen.GetString(9, 54, 3) 'Partner 1 Phone
obj.WorkSheets("Data Input").Cells(89, "A").Value = sess0.Screen.GetString(9, 60, 4) 'Partner 1 Phone
obj.WorkSheets("Data Input").Cells(90, "A").Value = sess0.Screen.GetString(16, 17, 53) 'Partner 1 Street
obj.WorkSheets("Data Input").Cells(91, "A").Value = sess0.Screen.GetString(17, 17, 30) 'Partner 1 City
obj.WorkSheets("Data Input").Cells(92, "A").Value = sess0.Screen.GetString(17, 56, 2) 'Partner 1 State
obj.WorkSheets("Data Input").Cells(93, "A").Value = sess0.Screen.GetString(17, 64, 5) 'Partner 1 Zip

Sess0.Screen.Sendkeys("<PF3>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop
End IF

IF obj.WorkSheets("Data Input").Cells(6, "I").Value > 0 Then
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.MoveTo 11,68
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("M")
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("<Enter>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop

Location = Trim(Sess0.Screen.GetString (04,09,4))
If Location = "FLAG" Then
Sess0.Screen.Sendkeys("<PF3>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop
End IF

obj.WorkSheets("Data Input").Cells(94, "A").Value = sess0.Screen.GetString(5, 27, 32) 'Partner 2 Name
obj.WorkSheets("Data Input").Cells(95, "A").Value = sess0.Screen.GetString(8, 10, 3) 'Partner 2 SSN
obj.WorkSheets("Data Input").Cells(96, "A").Value = sess0.Screen.GetString(8, 14, 2) 'Partner 2 SSN
obj.WorkSheets("Data Input").Cells(97, "A").Value = sess0.Screen.GetString(8, 17, 4) 'Partner 2 SSN
obj.WorkSheets("Data Input").Cells(98, "A").Value = sess0.Screen.GetString(8, 27, 2) 'Partner 2 DOB
obj.WorkSheets("Data Input").Cells(99, "A").Value = sess0.Screen.GetString(8, 30, 2) 'Partner 2 DOB
obj.WorkSheets("Data Input").Cells(100, "A").Value = sess0.Screen.GetString(8, 33, 4) 'Partner 2 DOB
obj.WorkSheets("Data Input").Cells(101, "A").Value = sess0.Screen.GetString(8, 50, 2) 'Partner 2 CDL ST
obj.WorkSheets("Data Input").Cells(102, "A").Value = sess0.Screen.GetString(8, 61, 8) 'Partner 2 CDL
obj.WorkSheets("Data Input").Cells(103, "A").Value = sess0.Screen.GetString(9, 10, 3) 'Partner 2 Phone
obj.WorkSheets("Data Input").Cells(104, "A").Value = sess0.Screen.GetString(9, 16, 3) 'Partner 2 Phone
obj.WorkSheets("Data Input").Cells(105, "A").Value = sess0.Screen.GetString(9, 22, 4) 'Partner 2 Phone
obj.WorkSheets("Data Input").Cells(106, "A").Value = sess0.Screen.GetString(9, 48, 3) 'Partner 2 Phone
obj.WorkSheets("Data Input").Cells(107, "A").Value = sess0.Screen.GetString(9, 54, 3) 'Partner 2 Phone
obj.WorkSheets("Data Input").Cells(108, "A").Value = sess0.Screen.GetString(9, 60, 4) 'Partner 2 Phone
obj.WorkSheets("Data Input").Cells(109, "A").Value = sess0.Screen.GetString(16, 17, 53) 'Partner 2 Street
obj.WorkSheets("Data Input").Cells(110, "A").Value = sess0.Screen.GetString(17, 17, 30) 'Partner 2 City
obj.WorkSheets("Data Input").Cells(111, "A").Value = sess0.Screen.GetString(17, 56, 2) 'Partner 2 State
obj.WorkSheets("Data Input").Cells(112, "A").Value = sess0.Screen.GetString(17, 64, 5) 'Partner 2 Zip

Sess0.Screen.Sendkeys("<PF3>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop
End IF

IF obj.WorkSheets("Data Input").Cells(7, "I").Value > 0 Then
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.MoveTo 12,68
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("M")
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("<Enter>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop

Location = Trim(Sess0.Screen.GetString (04,09,4))
If Location = "FLAG" Then
Sess0.Screen.Sendkeys("<PF3>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop
End IF

obj.WorkSheets("Data Input").Cells(113, "A").Value = sess0.Screen.GetString(5, 27, 32) 'Partner 3 Name
obj.WorkSheets("Data Input").Cells(114, "A").Value = sess0.Screen.GetString(8, 10, 3) 'Partner 3 SSN
obj.WorkSheets("Data Input").Cells(115, "A").Value = sess0.Screen.GetString(8, 14, 2) 'Partner 3 SSN
obj.WorkSheets("Data Input").Cells(116, "A").Value = sess0.Screen.GetString(8, 17, 4) 'Partner 3 SSN
obj.WorkSheets("Data Input").Cells(117, "A").Value = sess0.Screen.GetString(8, 27, 2) 'Partner 3 DOB
obj.WorkSheets("Data Input").Cells(118, "A").Value = sess0.Screen.GetString(8, 30, 2) 'Partner 3 DOB
obj.WorkSheets("Data Input").Cells(119, "A").Value = sess0.Screen.GetString(8, 33, 4) 'Partner 3 DOB
obj.WorkSheets("Data Input").Cells(120, "A").Value = sess0.Screen.GetString(8, 50, 2) 'Partner 3 CDL ST
obj.WorkSheets("Data Input").Cells(121, "A").Value = sess0.Screen.GetString(8, 61, 8) 'Partner 3 CDL
obj.WorkSheets("Data Input").Cells(122, "A").Value = sess0.Screen.GetString(9, 10, 3) 'Partner 3 Phone
obj.WorkSheets("Data Input").Cells(123, "A").Value = sess0.Screen.GetString(9, 16, 3) 'Partner 3 Phone
obj.WorkSheets("Data Input").Cells(124, "A").Value = sess0.Screen.GetString(9, 22, 4) 'Partner 3 Phone
obj.WorkSheets("Data Input").Cells(125, "A").Value = sess0.Screen.GetString(9, 48, 3) 'Partner 3 Phone
obj.WorkSheets("Data Input").Cells(126, "A").Value = sess0.Screen.GetString(9, 54, 3) 'Partner 3 Phone
obj.WorkSheets("Data Input").Cells(127, "A").Value = sess0.Screen.GetString(9, 60, 4) 'Partner 3 Phone
obj.WorkSheets("Data Input").Cells(128, "A").Value = sess0.Screen.GetString(16, 17, 53) 'Partner 3 Street
obj.WorkSheets("Data Input").Cells(129, "A").Value = sess0.Screen.GetString(17, 17, 30) 'Partner 3 City
obj.WorkSheets("Data Input").Cells(130, "A").Value = sess0.Screen.GetString(17, 56, 2) 'Partner 3 State
obj.WorkSheets("Data Input").Cells(131, "A").Value = sess0.Screen.GetString(17, 64, 5) 'Partner 3 Zip

Sess0.Screen.Sendkeys("<PF3>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop
End IF

IF obj.WorkSheets("Data Input").Cells(8, "I").Value > 0 Then
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.MoveTo 13,68
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("M")
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("<Enter>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop

Location = Trim(Sess0.Screen.GetString (04,09,4))
If Location = "FLAG" Then
Sess0.Screen.Sendkeys("<PF3>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop
End IF

obj.WorkSheets("Data Input").Cells(132, "A").Value = sess0.Screen.GetString(5, 27, 32) 'Partner 4 Name
obj.WorkSheets("Data Input").Cells(133, "A").Value = sess0.Screen.GetString(8, 10, 3) 'Partner 4 SSN
obj.WorkSheets("Data Input").Cells(134, "A").Value = sess0.Screen.GetString(8, 14, 2) 'Partner 4 SSN
obj.WorkSheets("Data Input").Cells(135, "A").Value = sess0.Screen.GetString(8, 17, 4) 'Partner 4 SSN
obj.WorkSheets("Data Input").Cells(136, "A").Value = sess0.Screen.GetString(8, 27, 2) 'Partner 4 DOB
obj.WorkSheets("Data Input").Cells(137, "A").Value = sess0.Screen.GetString(8, 30, 2) 'Partner 4 DOB
obj.WorkSheets("Data Input").Cells(138, "A").Value = sess0.Screen.GetString(8, 33, 4) 'Partner 4 DOB
obj.WorkSheets("Data Input").Cells(139, "A").Value = sess0.Screen.GetString(8, 50, 2) 'Partner 4 CDL ST
obj.WorkSheets("Data Input").Cells(140, "A").Value = sess0.Screen.GetString(8, 61, 8) 'Partner 4 CDL
obj.WorkSheets("Data Input").Cells(141, "A").Value = sess0.Screen.GetString(9, 10, 3) 'Partner 4 Phone
obj.WorkSheets("Data Input").Cells(142, "A").Value = sess0.Screen.GetString(9, 16, 3) 'Partner 4 Phone
obj.WorkSheets("Data Input").Cells(143, "A").Value = sess0.Screen.GetString(9, 22, 4) 'Partner 4 Phone
obj.WorkSheets("Data Input").Cells(144, "A").Value = sess0.Screen.GetString(9, 48, 3) 'Partner 4 Phone
obj.WorkSheets("Data Input").Cells(145, "A").Value = sess0.Screen.GetString(9, 54, 3) 'Partner 4 Phone
obj.WorkSheets("Data Input").Cells(146, "A").Value = sess0.Screen.GetString(9, 60, 4) 'Partner 4 Phone
obj.WorkSheets("Data Input").Cells(147, "A").Value = sess0.Screen.GetString(16, 17, 53) 'Partner 4 Street
obj.WorkSheets("Data Input").Cells(148, "A").Value = sess0.Screen.GetString(17, 17, 30) 'Partner 4 City
obj.WorkSheets("Data Input").Cells(149, "A").Value = sess0.Screen.GetString(17, 56, 2) 'Partner 4 State
obj.WorkSheets("Data Input").Cells(150, "A").Value = sess0.Screen.GetString(17, 64, 5) 'Partner 4 Zip

Sess0.Screen.Sendkeys("<PF3>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop
End IF

IF obj.WorkSheets("Data Input").Cells(9, "I").Value > 0 Then
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.MoveTo 14,68
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("M")
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("<Enter>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop

Location = Trim(Sess0.Screen.GetString (04,09,4))
If Location = "FLAG" Then
Sess0.Screen.Sendkeys("<PF3>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop
End IF

obj.WorkSheets("Data Input").Cells(151, "A").Value = sess0.Screen.GetString(5, 27, 32) 'Partner 5 Name
obj.WorkSheets("Data Input").Cells(152, "A").Value = sess0.Screen.GetString(8, 10, 3) 'Partner 5 SSN
obj.WorkSheets("Data Input").Cells(153, "A").Value = sess0.Screen.GetString(8, 14, 2) 'Partner 5 SSN
obj.WorkSheets("Data Input").Cells(154, "A").Value = sess0.Screen.GetString(8, 17, 4) 'Partner 5 SSN
obj.WorkSheets("Data Input").Cells(155, "A").Value = sess0.Screen.GetString(8, 27, 2) 'Partner 5 DOB
obj.WorkSheets("Data Input").Cells(156, "A").Value = sess0.Screen.GetString(8, 30, 2) 'Partner 5 DOB
obj.WorkSheets("Data Input").Cells(157, "A").Value = sess0.Screen.GetString(8, 33, 4) 'Partner 5 DOB
obj.WorkSheets("Data Input").Cells(158, "A").Value = sess0.Screen.GetString(8, 50, 2) 'Partner 5 CDL ST
obj.WorkSheets("Data Input").Cells(159, "A").Value = sess0.Screen.GetString(8, 61, 8) 'Partner 5 CDL
obj.WorkSheets("Data Input").Cells(160, "A").Value = sess0.Screen.GetString(9, 10, 3) 'Partner 5 Phone
obj.WorkSheets("Data Input").Cells(161, "A").Value = sess0.Screen.GetString(9, 16, 3) 'Partner 5 Phone
obj.WorkSheets("Data Input").Cells(162, "A").Value = sess0.Screen.GetString(9, 22, 4) 'Partner 5 Phone
obj.WorkSheets("Data Input").Cells(163, "A").Value = sess0.Screen.GetString(9, 48, 3) 'Partner 5 Phone
obj.WorkSheets("Data Input").Cells(164, "A").Value = sess0.Screen.GetString(9, 54, 3) 'Partner 5 Phone
obj.WorkSheets("Data Input").Cells(165, "A").Value = sess0.Screen.GetString(9, 60, 4) 'Partner 5 Phone
obj.WorkSheets("Data Input").Cells(166, "A").Value = sess0.Screen.GetString(16, 17, 53) 'Partner 5 Street
obj.WorkSheets("Data Input").Cells(167, "A").Value = sess0.Screen.GetString(17, 17, 30) 'Partner 5 City
obj.WorkSheets("Data Input").Cells(168, "A").Value = sess0.Screen.GetString(17, 56, 2) 'Partner 5 State
obj.WorkSheets("Data Input").Cells(169, "A").Value = sess0.Screen.GetString(17, 64, 5) 'Partner 5 Zip

Sess0.Screen.Sendkeys("<PF3>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop
End IF

IF obj.WorkSheets("Data Input").Cells(10, "I").Value > 0 Then
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.MoveTo 15,68
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("M")
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("<Enter>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop

Location = Trim(Sess0.Screen.GetString (04,09,4))
If Location = "FLAG" Then
Sess0.Screen.Sendkeys("<PF3>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop
End IF

obj.WorkSheets("Data Input").Cells(170, "A").Value = sess0.Screen.GetString(5, 27, 32) 'Partner 6 Name
obj.WorkSheets("Data Input").Cells(171, "A").Value = sess0.Screen.GetString(8, 10, 3) 'Partner 6 SSN
obj.WorkSheets("Data Input").Cells(172, "A").Value = sess0.Screen.GetString(8, 14, 2) 'Partner 6 SSN
obj.WorkSheets("Data Input").Cells(173, "A").Value = sess0.Screen.GetString(8, 17, 4) 'Partner 6 SSN
obj.WorkSheets("Data Input").Cells(174, "A").Value = sess0.Screen.GetString(8, 27, 2) 'Partner 6 DOB
obj.WorkSheets("Data Input").Cells(175, "A").Value = sess0.Screen.GetString(8, 30, 2) 'Partner 6 DOB
obj.WorkSheets("Data Input").Cells(176, "A").Value = sess0.Screen.GetString(8, 33, 4) 'Partner 6 DOB
obj.WorkSheets("Data Input").Cells(177, "A").Value = sess0.Screen.GetString(8, 50, 2) 'Partner 6 CDL ST
obj.WorkSheets("Data Input").Cells(178, "A").Value = sess0.Screen.GetString(8, 61, 8) 'Partner 6 CDL
obj.WorkSheets("Data Input").Cells(179, "A").Value = sess0.Screen.GetString(9, 10, 3) 'Partner 6 Phone
obj.WorkSheets("Data Input").Cells(180, "A").Value = sess0.Screen.GetString(9, 16, 3) 'Partner 6 Phone
obj.WorkSheets("Data Input").Cells(181, "A").Value = sess0.Screen.GetString(9, 22, 4) 'Partner 6 Phone
obj.WorkSheets("Data Input").Cells(182, "A").Value = sess0.Screen.GetString(9, 48, 3) 'Partner 6 Phone
obj.WorkSheets("Data Input").Cells(183, "A").Value = sess0.Screen.GetString(9, 54, 3) 'Partner 6 Phone
obj.WorkSheets("Data Input").Cells(184, "A").Value = sess0.Screen.GetString(9, 60, 4) 'Partner 6 Phone
obj.WorkSheets("Data Input").Cells(185, "A").Value = sess0.Screen.GetString(16, 17, 53) 'Partner 6 Street
obj.WorkSheets("Data Input").Cells(186, "A").Value = sess0.Screen.GetString(17, 17, 30) 'Partner 6 City
obj.WorkSheets("Data Input").Cells(187, "A").Value = sess0.Screen.GetString(17, 56, 2) 'Partner 6 State
obj.WorkSheets("Data Input").Cells(188, "A").Value = sess0.Screen.GetString(17, 64, 5) 'Partner 6 Zip

Sess0.Screen.Sendkeys("<PF3>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop
End IF

IF obj.WorkSheets("Data Input").Cells(11, "I").Value > 0 Then
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.MoveTo 16,68
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("M")
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("<Enter>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop

Location = Trim(Sess0.Screen.GetString (04,09,4))
If Location = "FLAG" Then
Sess0.Screen.Sendkeys("<PF3>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop
End IF

obj.WorkSheets("Data Input").Cells(189, "A").Value = sess0.Screen.GetString(5, 27, 32) 'Partner 7 Name
obj.WorkSheets("Data Input").Cells(190, "A").Value = sess0.Screen.GetString(8, 10, 3) 'Partner 7 SSN
obj.WorkSheets("Data Input").Cells(191, "A").Value = sess0.Screen.GetString(8, 14, 2) 'Partner 7 SSN
obj.WorkSheets("Data Input").Cells(192, "A").Value = sess0.Screen.GetString(8, 17, 4) 'Partner 7 SSN
obj.WorkSheets("Data Input").Cells(193, "A").Value = sess0.Screen.GetString(8, 27, 2) 'Partner 7 DOB
obj.WorkSheets("Data Input").Cells(194, "A").Value = sess0.Screen.GetString(8, 30, 2) 'Partner 7 DOB
obj.WorkSheets("Data Input").Cells(195, "A").Value = sess0.Screen.GetString(8, 33, 4) 'Partner 7 DOB
obj.WorkSheets("Data Input").Cells(196, "A").Value = sess0.Screen.GetString(8, 50, 2) 'Partner 7 CDL ST
obj.WorkSheets("Data Input").Cells(197, "A").Value = sess0.Screen.GetString(8, 61, 8) 'Partner 7 CDL
obj.WorkSheets("Data Input").Cells(198, "A").Value = sess0.Screen.GetString(9, 10, 3) 'Partner 7 Phone
obj.WorkSheets("Data Input").Cells(199, "A").Value = sess0.Screen.GetString(9, 16, 3) 'Partner 7 Phone
obj.WorkSheets("Data Input").Cells(200, "A").Value = sess0.Screen.GetString(9, 22, 4) 'Partner 7 Phone
obj.WorkSheets("Data Input").Cells(201, "A").Value = sess0.Screen.GetString(9, 48, 3) 'Partner 7 Phone
obj.WorkSheets("Data Input").Cells(202, "A").Value = sess0.Screen.GetString(9, 54, 3) 'Partner 7 Phone
obj.WorkSheets("Data Input").Cells(203, "A").Value = sess0.Screen.GetString(9, 60, 4) 'Partner 7 Phone
obj.WorkSheets("Data Input").Cells(204, "A").Value = sess0.Screen.GetString(16, 17, 53) 'Partner 7 Street
obj.WorkSheets("Data Input").Cells(205, "A").Value = sess0.Screen.GetString(17, 17, 30) 'Partner 7 City
obj.WorkSheets("Data Input").Cells(206, "A").Value = sess0.Screen.GetString(17, 56, 2) 'Partner 7 State
obj.WorkSheets("Data Input").Cells(207, "A").Value = sess0.Screen.GetString(17, 64, 5) 'Partner 7 Zip

Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("<PF3>")
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("<PF3>")
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("<PF3>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop
End IF

End IF


If my_dialog.CheckBox3 Then

Set Sys = CreateObject("EXTRA.System")
Set Sess = Sys.ActiveSession
Set MyScreen = Sess.Screen
Set MyArea = MyScreen.Area(4, 10, 4, 20)
MyArea.Select
MyScreen.Copy

Sess0.Screen.Putstring "CTS", 21, 5
Sess0.Screen.Putstring "CM", 21, 9
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop

Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.MoveTo 21,12
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Paste
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.SendKeys ("<Enter>")
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop

Location = Trim(Sess0.Screen.GetString (04,09,4))
If Location = "FLAG" Then
Pause 1
Sess0.Screen.Sendkeys("<PF3>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop
End IF

obj.WorkSheets("Data Input").Cells(3, "G").Value = sess0.Screen.GetString(4, 15, 11) 'Corporation Tin
obj.WorkSheets("Data Input").Cells(208, "A").Value = sess0.Screen.GetString(5, 27, 32) 'Corporation Name
obj.WorkSheets("Data Input").Cells(209, "A").Value = sess0.Screen.GetString(9, 10, 3) 'Corporation Phone
obj.WorkSheets("Data Input").Cells(210, "A").Value = sess0.Screen.GetString(9, 16, 3) 'Corporation Phone
obj.WorkSheets("Data Input").Cells(211, "A").Value = sess0.Screen.GetString(9, 22, 4) 'Corporation Phone
obj.WorkSheets("Data Input").Cells(212, "A").Value = sess0.Screen.GetString(16, 17, 51) 'Corporation Street
obj.WorkSheets("Data Input").Cells(213, "A").Value = sess0.Screen.GetString(17, 17, 31) 'Corporation City
obj.WorkSheets("Data Input").Cells(214, "A").Value = sess0.Screen.GetString(17, 56, 2) 'Corporation State
obj.WorkSheets("Data Input").Cells(215, "A").Value = sess0.Screen.GetString(17, 64, 5) 'Corporation Zip
Sess0.Screen.Sendkeys("<PF10>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop
End IF

obj.WorkSheets("Data Input").Cells(5, "I").Value = sess0.Screen.GetString(10, 69, 9) 'Tin 1
obj.WorkSheets("Data Input").Cells(6, "I").Value = sess0.Screen.GetString(11, 69, 9) 'Tin 2
obj.WorkSheets("Data Input").Cells(7, "I").Value = sess0.Screen.GetString(12, 69, 9) 'Tin 3
obj.WorkSheets("Data Input").Cells(8, "I").Value = sess0.Screen.GetString(13, 69, 9) 'Tin 4
obj.WorkSheets("Data Input").Cells(9, "I").Value = sess0.Screen.GetString(14, 69, 9) 'Tin 5
obj.WorkSheets("Data Input").Cells(10, "I").Value = sess0.Screen.GetString(15, 69, 9) 'Tin 6
obj.WorkSheets("Data Input").Cells(11, "I").Value = sess0.Screen.GetString(16, 69, 9) 'Tin 7
obj.WorkSheets("Data Input").Cells(216, "A").Value = sess0.Screen.GetString(10, 13, 1) 'Corporate Officer Code
obj.WorkSheets("Data Input").Cells(236, "A").Value = sess0.Screen.GetString(11, 13, 1) 'Corporate Officer Code
obj.WorkSheets("Data Input").Cells(256, "A").Value = sess0.Screen.GetString(12, 13, 1) 'Corporate Officer Code
obj.WorkSheets("Data Input").Cells(276, "A").Value = sess0.Screen.GetString(13, 13, 1) 'Corporate Officer Code
obj.WorkSheets("Data Input").Cells(296, "A").Value = sess0.Screen.GetString(14, 13, 1) 'Corporate Officer Code
obj.WorkSheets("Data Input").Cells(316, "A").Value = sess0.Screen.GetString(15, 13, 1) 'Corporate Officer Code
obj.WorkSheets("Data Input").Cells(336, "A").Value = sess0.Screen.GetString(16, 13, 1) 'Corporate Officer Code

IF obj.WorkSheets("Data Input").Cells(5, "I").Value > 0 Then
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.MoveTo 10,67
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("M")
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("<Enter>")
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.MoveTo 9,31
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("Y")
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("<Enter>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop

Location = Trim(Sess0.Screen.GetString (04,09,4))
If Location = "FLAG" Then
Sess0.Screen.Sendkeys("<PF3>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop
End IF

obj.WorkSheets("Data Input").Cells(217, "A").Value = sess0.Screen.GetString(5, 27, 32) 'Officer 1 Name
obj.WorkSheets("Data Input").Cells(218, "A").Value = sess0.Screen.GetString(8, 10, 3) 'Officer 1 SSN
obj.WorkSheets("Data Input").Cells(219, "A").Value = sess0.Screen.GetString(8, 14, 2) 'Officer 1 SSN
obj.WorkSheets("Data Input").Cells(220, "A").Value = sess0.Screen.GetString(8, 17, 4) 'Officer 1 SSN
obj.WorkSheets("Data Input").Cells(221, "A").Value = sess0.Screen.GetString(8, 27, 2) 'Officer 1 DOB
obj.WorkSheets("Data Input").Cells(222, "A").Value = sess0.Screen.GetString(8, 30, 2) 'Officer 1 DOB
obj.WorkSheets("Data Input").Cells(223, "A").Value = sess0.Screen.GetString(8, 33, 4) 'Officer 1 DOB
obj.WorkSheets("Data Input").Cells(224, "A").Value = sess0.Screen.GetString(8, 50, 2) 'Officer 1 CDL ST
obj.WorkSheets("Data Input").Cells(225, "A").Value = sess0.Screen.GetString(8, 61, 8) 'Officer 1 CDL
obj.WorkSheets("Data Input").Cells(226, "A").Value = sess0.Screen.GetString(9, 10, 3) 'Officer 1 Phone
obj.WorkSheets("Data Input").Cells(227, "A").Value = sess0.Screen.GetString(9, 16, 3) 'Officer 1 Phone
obj.WorkSheets("Data Input").Cells(228, "A").Value = sess0.Screen.GetString(9, 22, 4) 'Officer 1 Phone
obj.WorkSheets("Data Input").Cells(229, "A").Value = sess0.Screen.GetString(9, 48, 3) 'Officer 1 Phone
obj.WorkSheets("Data Input").Cells(230, "A").Value = sess0.Screen.GetString(9, 54, 3) 'Officer 1 Phone
obj.WorkSheets("Data Input").Cells(231, "A").Value = sess0.Screen.GetString(9, 60, 4) 'Officer 1 Phone
obj.WorkSheets("Data Input").Cells(232, "A").Value = sess0.Screen.GetString(16, 17, 53) 'Officer 1 Street
obj.WorkSheets("Data Input").Cells(233, "A").Value = sess0.Screen.GetString(17, 17, 30) 'Officer 1 City
obj.WorkSheets("Data Input").Cells(234, "A").Value = sess0.Screen.GetString(17, 56, 2) 'Officer 1 State
obj.WorkSheets("Data Input").Cells(235, "A").Value = sess0.Screen.GetString(17, 64, 5) 'Officer 1 Zip

obj.WorkSheets("Data Input").Cells(3, "G").copy
Sess0.Screen.Putstring "CTS", 21, 5
Sess0.Screen.Putstring "CM", 21, 9
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.MoveTo 21,12
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.paste
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("<Enter>")
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop

Location = Trim(Sess0.Screen.GetString (04,09,4))
If Location = "FLAG" Then
Sess0.Screen.Sendkeys("<PF3>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop
End IF

Sess0.Screen.Sendkeys("<PF10>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop
End IF

IF obj.WorkSheets("Data Input").Cells(6, "I").Value > 0 Then
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.MoveTo 11,67
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("M")
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("<Enter>")
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.MoveTo 9,31
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("Y")
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("<Enter>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop

Location = Trim(Sess0.Screen.GetString (04,09,4))
If Location = "FLAG" Then
Sess0.Screen.Sendkeys("<PF3>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop
End IF

obj.WorkSheets("Data Input").Cells(237, "A").Value = sess0.Screen.GetString(5, 27, 32) 'Officer 2 Name
obj.WorkSheets("Data Input").Cells(238, "A").Value = sess0.Screen.GetString(8, 10, 3) 'Officer 2 SSN
obj.WorkSheets("Data Input").Cells(239, "A").Value = sess0.Screen.GetString(8, 14, 2) 'Officer 2 SSN
obj.WorkSheets("Data Input").Cells(240, "A").Value = sess0.Screen.GetString(8, 17, 4) 'Officer 2 SSN
obj.WorkSheets("Data Input").Cells(241, "A").Value = sess0.Screen.GetString(8, 27, 2) 'Officer 2 DOB
obj.WorkSheets("Data Input").Cells(242, "A").Value = sess0.Screen.GetString(8, 30, 2) 'Officer 2 DOB
obj.WorkSheets("Data Input").Cells(243, "A").Value = sess0.Screen.GetString(8, 33, 4) 'Officer 2 DOB
obj.WorkSheets("Data Input").Cells(244, "A").Value = sess0.Screen.GetString(8, 50, 2) 'Officer 2 CDL ST
obj.WorkSheets("Data Input").Cells(245, "A").Value = sess0.Screen.GetString(8, 61, 8) 'Officer 2 CDL
obj.WorkSheets("Data Input").Cells(246, "A").Value = sess0.Screen.GetString(9, 10, 3) 'Officer 2 Phone
obj.WorkSheets("Data Input").Cells(247, "A").Value = sess0.Screen.GetString(9, 16, 3) 'Officer 2 Phone
obj.WorkSheets("Data Input").Cells(248, "A").Value = sess0.Screen.GetString(9, 22, 4) 'Officer 2 Phone
obj.WorkSheets("Data Input").Cells(249, "A").Value = sess0.Screen.GetString(9, 48, 3) 'Officer 2 Phone
obj.WorkSheets("Data Input").Cells(250, "A").Value = sess0.Screen.GetString(9, 54, 3) 'Officer 2 Phone
obj.WorkSheets("Data Input").Cells(251, "A").Value = sess0.Screen.GetString(9, 60, 4) 'Officer 2 Phone
obj.WorkSheets("Data Input").Cells(252, "A").Value = sess0.Screen.GetString(16, 17, 53) 'Officer 2 Street
obj.WorkSheets("Data Input").Cells(253, "A").Value = sess0.Screen.GetString(17, 17, 30) 'Officer 2 City
obj.WorkSheets("Data Input").Cells(254, "A").Value = sess0.Screen.GetString(17, 56, 2) 'Officer 2 State
obj.WorkSheets("Data Input").Cells(255, "A").Value = sess0.Screen.GetString(17, 64, 5) 'Officer 2 Zip

obj.WorkSheets("Data Input").Cells(3, "G").copy
Sess0.Screen.Putstring "CTS", 21, 5
Sess0.Screen.Putstring "CM", 21, 9
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.MoveTo 21,12
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.paste
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("<Enter>")
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop

Location = Trim(Sess0.Screen.GetString (04,09,4))
If Location = "FLAG" Then
Sess0.Screen.Sendkeys("<PF3>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop
End IF

Sess0.Screen.Sendkeys("<PF10>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop
End IF

IF obj.WorkSheets("Data Input").Cells(7, "I").Value > 0 Then
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.MoveTo 12,67
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("M")
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("<Enter>")
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.MoveTo 9,31
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("Y")
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("<Enter>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop

Location = Trim(Sess0.Screen.GetString (04,09,4))
If Location = "FLAG" Then
Sess0.Screen.Sendkeys("<PF3>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop
End IF

obj.WorkSheets("Data Input").Cells(257, "A").Value = sess0.Screen.GetString(5, 27, 32) 'Officer 3 Name
obj.WorkSheets("Data Input").Cells(258, "A").Value = sess0.Screen.GetString(8, 10, 3) 'Officer 3 SSN
obj.WorkSheets("Data Input").Cells(259, "A").Value = sess0.Screen.GetString(8, 14, 2) 'Officer 3 SSN
obj.WorkSheets("Data Input").Cells(260, "A").Value = sess0.Screen.GetString(8, 17, 4) 'Officer 3 SSN
obj.WorkSheets("Data Input").Cells(261, "A").Value = sess0.Screen.GetString(8, 27, 2) 'Officer 3 DOB
obj.WorkSheets("Data Input").Cells(262, "A").Value = sess0.Screen.GetString(8, 30, 2) 'Officer 3 DOB
obj.WorkSheets("Data Input").Cells(263, "A").Value = sess0.Screen.GetString(8, 33, 4) 'Officer 3 DOB
obj.WorkSheets("Data Input").Cells(264, "A").Value = sess0.Screen.GetString(8, 50, 2) 'Officer 3 CDL ST
obj.WorkSheets("Data Input").Cells(265, "A").Value = sess0.Screen.GetString(8, 61, 8) 'Officer 3 CDL
obj.WorkSheets("Data Input").Cells(266, "A").Value = sess0.Screen.GetString(9, 10, 3) 'Officer 3 Phone
obj.WorkSheets("Data Input").Cells(267, "A").Value = sess0.Screen.GetString(9, 16, 3) 'Officer 3 Phone
obj.WorkSheets("Data Input").Cells(268, "A").Value = sess0.Screen.GetString(9, 22, 4) 'Officer 3 Phone
obj.WorkSheets("Data Input").Cells(269, "A").Value = sess0.Screen.GetString(9, 48, 3) 'Officer 3 Phone
obj.WorkSheets("Data Input").Cells(270, "A").Value = sess0.Screen.GetString(9, 54, 3) 'Officer 3 Phone
obj.WorkSheets("Data Input").Cells(271, "A").Value = sess0.Screen.GetString(9, 60, 4) 'Officer 3 Phone
obj.WorkSheets("Data Input").Cells(272, "A").Value = sess0.Screen.GetString(16, 17, 53) 'Officer 3 Street
obj.WorkSheets("Data Input").Cells(273, "A").Value = sess0.Screen.GetString(17, 17, 30) 'Officer 3 City
obj.WorkSheets("Data Input").Cells(274, "A").Value = sess0.Screen.GetString(17, 56, 2) 'Officer 3 State
obj.WorkSheets("Data Input").Cells(275, "A").Value = sess0.Screen.GetString(17, 64, 5) 'Officer 3 Zip

obj.WorkSheets("Data Input").Cells(3, "G").copy
Sess0.Screen.Putstring "CTS", 21, 5
Sess0.Screen.Putstring "CM", 21, 9
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.MoveTo 21,12
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.paste
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("<Enter>")
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop


Location = Trim(Sess0.Screen.GetString (04,09,4))
If Location = "FLAG" Then
Sess0.Screen.Sendkeys("<PF3>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop
End IF

Sess0.Screen.Sendkeys("<PF10>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop
End IF

IF obj.WorkSheets("Data Input").Cells(8, "I").Value > 0 Then
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.MoveTo 13,67
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("M")
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("<Enter>")
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.MoveTo 9,31
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("Y")
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("<Enter>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop

Location = Trim(Sess0.Screen.GetString (04,09,4))
If Location = "FLAG" Then
Sess0.Screen.Sendkeys("<PF3>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop
End IF

obj.WorkSheets("Data Input").Cells(277, "A").Value = sess0.Screen.GetString(5, 27, 32) 'Officer 4 Name
obj.WorkSheets("Data Input").Cells(278, "A").Value = sess0.Screen.GetString(8, 10, 3) 'Officer 4 SSN
obj.WorkSheets("Data Input").Cells(279, "A").Value = sess0.Screen.GetString(8, 14, 2) 'Officer 4 SSN
obj.WorkSheets("Data Input").Cells(280, "A").Value = sess0.Screen.GetString(8, 17, 4) 'Officer 4 SSN
obj.WorkSheets("Data Input").Cells(281, "A").Value = sess0.Screen.GetString(8, 27, 2) 'Officer 4 DOB
obj.WorkSheets("Data Input").Cells(282, "A").Value = sess0.Screen.GetString(8, 30, 2) 'Officer 4 DOB
obj.WorkSheets("Data Input").Cells(283, "A").Value = sess0.Screen.GetString(8, 33, 4) 'Officer 4 DOB
obj.WorkSheets("Data Input").Cells(284, "A").Value = sess0.Screen.GetString(8, 50, 2) 'Officer 4 CDL ST
obj.WorkSheets("Data Input").Cells(285, "A").Value = sess0.Screen.GetString(8, 61, 8) 'Officer 4 CDL
obj.WorkSheets("Data Input").Cells(286, "A").Value = sess0.Screen.GetString(9, 10, 3) 'Officer 4 Phone
obj.WorkSheets("Data Input").Cells(287, "A").Value = sess0.Screen.GetString(9, 16, 3) 'Officer 4 Phone
obj.WorkSheets("Data Input").Cells(288, "A").Value = sess0.Screen.GetString(9, 22, 4) 'Officer 4 Phone
obj.WorkSheets("Data Input").Cells(289, "A").Value = sess0.Screen.GetString(9, 48, 3) 'Officer 4 Phone
obj.WorkSheets("Data Input").Cells(290, "A").Value = sess0.Screen.GetString(9, 54, 3) 'Officer 4 Phone
obj.WorkSheets("Data Input").Cells(291, "A").Value = sess0.Screen.GetString(9, 60, 4) 'Officer 4 Phone
obj.WorkSheets("Data Input").Cells(292, "A").Value = sess0.Screen.GetString(16, 17, 53) 'Officer 4 Street
obj.WorkSheets("Data Input").Cells(293, "A").Value = sess0.Screen.GetString(17, 17, 30) 'Officer 4 City
obj.WorkSheets("Data Input").Cells(294, "A").Value = sess0.Screen.GetString(17, 56, 2) 'Officer 4 State
obj.WorkSheets("Data Input").Cells(295, "A").Value = sess0.Screen.GetString(17, 64, 5) 'Officer 4 Zip

obj.WorkSheets("Data Input").Cells(3, "G").copy
Sess0.Screen.Putstring "CTS", 21, 5
Sess0.Screen.Putstring "CM", 21, 9
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.MoveTo 21,12
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.paste
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("<Enter>")
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop

Location = Trim(Sess0.Screen.GetString (04,09,4))
If Location = "FLAG" Then
Sess0.Screen.Sendkeys("<PF3>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop
End IF

Sess0.Screen.Sendkeys("<PF10>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop
End IF

IF obj.WorkSheets("Data Input").Cells(9, "I").Value > 0 Then
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.MoveTo 14,67
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("M")
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("<Enter>")
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.MoveTo 9,31
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("Y")
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("<Enter>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop

Location = Trim(Sess0.Screen.GetString (04,09,4))
If Location = "FLAG" Then
Sess0.Screen.Sendkeys("<PF3>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop
End IF

obj.WorkSheets("Data Input").Cells(297, "A").Value = sess0.Screen.GetString(5, 27, 32) 'Officer 5 Name
obj.WorkSheets("Data Input").Cells(298, "A").Value = sess0.Screen.GetString(8, 10, 3) 'Officer 5 SSN
obj.WorkSheets("Data Input").Cells(299, "A").Value = sess0.Screen.GetString(8, 14, 2) 'Officer 5 SSN
obj.WorkSheets("Data Input").Cells(300, "A").Value = sess0.Screen.GetString(8, 17, 4) 'Officer 5 SSN
obj.WorkSheets("Data Input").Cells(301, "A").Value = sess0.Screen.GetString(8, 27, 2) 'Officer 5 DOB
obj.WorkSheets("Data Input").Cells(302, "A").Value = sess0.Screen.GetString(8, 30, 2) 'Officer 5 DOB
obj.WorkSheets("Data Input").Cells(303, "A").Value = sess0.Screen.GetString(8, 33, 4) 'Officer 5 DOB
obj.WorkSheets("Data Input").Cells(304, "A").Value = sess0.Screen.GetString(8, 50, 2) 'Officer 5 CDL ST
obj.WorkSheets("Data Input").Cells(305, "A").Value = sess0.Screen.GetString(8, 61, 8) 'Officer 5 CDL
obj.WorkSheets("Data Input").Cells(306, "A").Value = sess0.Screen.GetString(9, 10, 3) 'Officer 5 Phone
obj.WorkSheets("Data Input").Cells(307, "A").Value = sess0.Screen.GetString(9, 16, 3) 'Officer 5 Phone
obj.WorkSheets("Data Input").Cells(308, "A").Value = sess0.Screen.GetString(9, 22, 4) 'Officer 5 Phone
obj.WorkSheets("Data Input").Cells(309, "A").Value = sess0.Screen.GetString(9, 48, 3) 'Officer 5 Phone
obj.WorkSheets("Data Input").Cells(310, "A").Value = sess0.Screen.GetString(9, 54, 3) 'Officer 5 Phone
obj.WorkSheets("Data Input").Cells(311, "A").Value = sess0.Screen.GetString(9, 60, 4) 'Officer 5 Phone
obj.WorkSheets("Data Input").Cells(312, "A").Value = sess0.Screen.GetString(16, 17, 53) 'Officer 5 Street
obj.WorkSheets("Data Input").Cells(313, "A").Value = sess0.Screen.GetString(17, 17, 30) 'Officer 5 City
obj.WorkSheets("Data Input").Cells(314, "A").Value = sess0.Screen.GetString(17, 56, 2) 'Officer 5 State
obj.WorkSheets("Data Input").Cells(315, "A").Value = sess0.Screen.GetString(17, 64, 5) 'Officer 5 Zip

obj.WorkSheets("Data Input").Cells(3, "G").copy
Sess0.Screen.Putstring "CTS", 21, 5
Sess0.Screen.Putstring "CM", 21, 9
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.MoveTo 21,12
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.paste
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("<Enter>")
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop

Location = Trim(Sess0.Screen.GetString (04,09,4))
If Location = "FLAG" Then
Sess0.Screen.Sendkeys("<PF3>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop
End IF

Sess0.Screen.Sendkeys("<PF10>")
Do While sess0.Screen.OIA.Xstatus <> 0
DoEvents
Loop
End IF

IF obj.WorkSheets("Data Input").Cells(10, "I").Value > 0 Then
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.MoveTo 15,67
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("M")
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("<Enter>")
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.MoveTo 9,31
Sess0.Screen.WaitHostQuiet(g_HostSettleTime)
Sess0.Screen.Sendkeys("Y")
Sess0.Screen.WaitHostQuiet(
 
Sort by date Sort by votes
if you post your code with the tags, it's much easier to decipher
 
Upvote 0 Downvote
I found and read that earlier, but then I couldn't get the 2nd macro to run when I split it at the dialog box. Numerous errors pop-up that weren't there when I had less lines in the original macro. I'm also not certain if that will work as the 2nd half of the macro is just over 1000 lines and may still be too big. I'm going to give it another go though.

Yes, there should never be a last question. This has started causing my head to hurt from all of the highs and lows involved with this. I fully thought it would run and forgot that it might be too big. :(
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

247xavi
  • Locked
  • Question
Attachmate to BlueZone
Replies
0
Views
127
247xavi
247xavi
nightrider69
  • Locked
  • Question
Micro mainframe transmission issues using Attachmate myExtra
Replies
0
Views
155
nightrider69
nightrider69
CADD6953
  • Locked
  • Question
Help needed with syntax/logic in Attachmate macro
2
Replies
26
Views
473
SkipVought
S
Suresh02
  • Locked
  • Question
Automation error 'Specified module could not be found&quot;
Replies
0
Views
108
Suresh02
Suresh02
FreCard
  • Locked
  • Question
Extra macro example
Replies
3
Views
267
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top