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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Attachmate Macro, One Macro to Rule Them All

Status
Not open for further replies.
afortuna98

afortuna98

Programmer
Apr 4, 2014
28
US
I'm working from that link Skip provided, Combining Two or More EXTRA! Macros into One. Ok, when I placed two "Include Statements" before "Sub Main()" ['$Include: "Pei.EBH" and '$Include: "Cei.EBH" on separate lines] and then placed "Pei" and "Cei" calls where I need them to run, it says that they are "Unknown Function" on each of them. What am I doing wrong now? Also, on some rare tries, it tells me it can't find the file in the C:\Windows\System32 folder. They aren't there and have never been there. The two EBH files Compile fine. They are in the same folder as all of my Xtra macros and EBH files are located.

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

' Global variable declarations
Global g_HostSettleTime%
Global g_szPassword$

'$Include: "Pei.EBH"
'$Include: "Cei.EBH"
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
PEI

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
CEI
End IF
System.TimeoutValue = OldSystemTimeout

End Sub
 
Status
Not open for further replies.

Similar threads

247xavi
  • Locked
  • Question
Attachmate to BlueZone
Replies
0
Views
109
247xavi
247xavi
nightrider69
  • Locked
  • Question
Micro mainframe transmission issues using Attachmate myExtra
Replies
0
Views
137
nightrider69
nightrider69
S
  • Locked
  • Question
Reflection Workspace extract all screen/pages
Replies
0
Views
165
SSS27
S
CADD6953
  • Locked
  • Question
Help needed with syntax/logic in Attachmate macro
2
Replies
26
Views
392
SkipVought
S
FreCard
  • Locked
  • Question
Extra macro example
Replies
3
Views
228
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top