×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Attachmate Macro, One Macro to Rule Them All

Attachmate Macro, One Macro to Rule Them All

Attachmate Macro, One Macro to Rule Them All

(OP)
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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close