Need help to understand fields

IamNewbee

New Member
Joined
Sep 18, 2017
Messages
7
Hi Guys, I have a piece of code which can be used to connect excel with mainframe application.
Below is the code which works perfectly:
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 = 300 ' 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)


I understand the overall working of this code but would like to study each fields(like g_HostSettleTime,OldSystemTimeout etc) deeply. I tried to search for the explanation on the internet but no luck. Could anyone share links/documents where these fields are explained properly. I would appreciate if someone can explain it to me if you don't have any material.
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
Have you tried contacting Rocket Software to see if they have some documentation?
 
Upvote 0
What you're showing is almost the identical macro I use when opening my Extra session. It's saved in a file with a .ebm extension. If you open that file, it should open the macro in the Extra macro editor. On the toolbar on the top of the window is a Help option. Click on that, click Find, and enter the word you want, for example "settletime". You should be able to find anything you need there. g_hostsettletime is the number of milliseconds that Extra will wait after issuing a command to the mainframe before continuing with its processing.

You might also get to the editor from an Extra session. Click on Tools > Macro > select one of the macros and click Edit.

You may have a different version of Extra, so your mileage may vary, but you should still be able to find the help screens from the macro editor.
 
Upvote 0

Forum statistics

Threads
1,223,162
Messages
6,170,432
Members
452,326
Latest member
johnshaji

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top