Macro Language Reference Manual
Preamble
Introduction
Variables and Data Types
Data Types
Variable identifiers
Label identifiers
Declaring Variable
Dim Statement
Const Statement.
Build-In Symbolic Constants.
Data Type Functions
Is
IsEmpty
IsNull
IsNumeric
VarType
Control Commands
Call Statement
Do While...Loop
End
Exit
Exit Session
Exit Sub
For...Next Statement
GoSub
GoTo
If...Then...Else Statement
Quit
Return
Stop
Sub...End Sub Statement
While...Wend Statement
Whith...End With Statement
String functions
Chr or Chr$
CStr
InStr
LCase or LCase$
Left or Left$
Len
Mid or Mid$
Replace or Replace$
Right or Right$
Space or Space$
Str or Str$
StrComp
Trim
UCase or UCase$
Val
File functions and statements
Open
Close
LineInput or Line Input
Print #
Write #
Seek #
Get #
Put #
EOF
FreeFile
Loc
LOF
Kill
Date / Time functions
Build-In Symbolic Constants.
Date$
Date
Time$
Time
Day
Month
Year
DateAdd
DateSerial
DateValue
Format
Now
TimeSerial
TimeValue
COM functions
CreateObject
GetObject
Miscellaneous functions and statements
Beep
Decrypt or Decrypt$
Encrypt or Encrypt$
Environ or Environ$
GetOpenFileName
GetSpecialFolderLocation
InputBox
MsgBox
PasswordBox
Rem
Shell
Quick3270 functions and statements
ConvertCol
ConvertRow
EditCopy
EditCopyAdd
EditPaste
EditSelectAll
GetCol
GetCols
GetRow
GetRows
GetRowCount
GetColor
GetIpAddress
GetIpAddressV6
GetMacroKeystroke
GetOIA
GetString
GetText
GetTextRect
GetTimeoutValue
GetVisible
GetWindowTitle
MoveTo
MoveRelative
OpenPrinter
ClosePrinter
PrintScreenFontSize
PrintScreen
PutString
ReceiveFile
Search
SearchPS
SendDarkKeys
SendFile
SendKeys
SetText
SetTimeoutValue
SetVisible
SetWindowTitle
Updated
WaitForAttrib
WaitForCursor
WaitForCursorMove
WaitForKbdUnlock
WaitForString
WaitHostQuiet
Support for IBM® Personal Communications™ macros
autECLSession
autECLSession.Name
autECLSession.SetConnectionByName
autECLSession.StopCommunication
autECLSession.StartCommunication
autECLPS
autECLOIA
autECLWinMetrics
autECLXfer
autECLPS
autECLPS.NumRows
autECLPS.NumCols
autECLPS.CursorPosRow
autECLPS.CursorPosCol
autECLPS.ConnType
autECLPS.SetCursorPos
autECLPS.SendKeys
autECLPS.SearchText
autECLPS.GetText
autECLPS.SetText
autECLPS.GetTextRect
autECLPS.Wait
autECLPS.WaitForCursor
autECLPS.WaitWhileCursor
autECLPS.WaitForString
autECLPS.WaitForAttrib
autECLFieldList
autECLXfer
autECLXfer.ReceiveFile
autECLXfer.SendFile
autECLWinMetrics
autECLWinMetrics.WindowTitle
autECLWinMetrics.Visible
autECLWinMetrics.Minimized
autECLWinMetrics.Maximized
autECLWinMetrics.Restored
autECLWinMetrics.Name
autECLOIA
autECLOIA.WaitForInputReady
autECLOIA.WaitForAppAvailable
autECLOIA.WaitForSystemAvailable
autECLFieldList
autECLFieldList.Refresh
autECLFieldList.Count
autECLFieldList.FindFieldByRowCol
autECLFieldList.FindFieldByText
autECLFieldList(FieldIndex).Display
autECLFieldList(FieldIndex).GetText
autECLFieldList(FieldIndex).SetText
autECLFieldList(FieldIndex).StartCol
autECLFieldList(FieldIndex).StartRow
autECLFieldList(FieldIndex).EndCol
autECLFieldList(FieldIndex).EndRow
autECLFieldList(FieldIndex).Length
autECLFieldList(FieldIndex).Modified
autECLFieldList(FieldIndex).Protected
autECLFieldList(FieldIndex).HighIntensity
autECLFieldList(FieldIndex).PenDetectable
autECLFieldList(FieldIndex).Numeric
autSystem.Inputnd
Support for Attachmate’s Extra! X-treme™ macros
Support for Micro Focus Chameleon™/Rumba™ macros
EMReadScreen
EMSendKey
EMWaitCursor
FileWrite
FileAppend
Support for TN3270 Plus™ macros
Chr
DDEExecute
DDEInitiate
DDEPoke
DDERequest
DDETerminate
Command
CursorTo
Key
MsgBox
Replace
Run
Type
Wait
WaitFor
Macro Samples
Select an Excel file using GetOpenFileName
Creating a Reference to an Excel Object
File I/O
Connecting to a data source and executing SQL Queries
Find Values from screen and use the WScript object
Simple logon script
Using LDAP to retrieve the user name and password and start logon script
IBM Personal CommunicationsVBScript sample supported by Quick3270
IBM Personal CommunicationsMacro sample supported by Quick3270
Attachmate’s Extra! macro sample supported by Quick3270