Macro

Description

Sub API_BCC_EI_SetScript(ByRef pWorkbook As Workbook, pScript As String)

Chooses the EasyInput script

pScript - Script ID or Script name to be set

Function API_BCC_EI_GetScriptName(ByRef pWorkbook As Workbook, Optional ByVal pError As Boolean = True) As String

Returns the selected script name

Function API_BCC_EI_GetScriptID(ByRef pWorkbook As Workbook, Optional ByVal pError As Boolean = True) As String

Returns the selected script ID

Sub API_BCC_EI_SetRunType(ByRef pWorkbook As Workbook, pRT As String)

Sets the run mode
pRT - Run mode- possible values:
TR

TE

TN

AR

AE

AN

Function API_BCC_EI_GetRunType(ByRef pWorkbook As Workbook) As String

Returns the selected run mode (TR,TE,TN,AR,AE,AN)

Sub API_BCC_EI_SetDataSheet(ByRef pWorkbook As Workbook, pDataSheet As String)

Sets the data sheet
pDataSheet - Name of the data sheet on the EI_Config worksheet

Function API_BCC_EI_GetDataSheet(ByRef pWorkbook As Workbook) As String

Returns the name of the data sheet

Function API_BCC_EI_RunScript(ByRef pWorkbook As Workbook) As Boolean

Runs the set EasyInput script

Sub API_BCC_EI_ClearLevelOrder(ByRef pWorkbook As Workbook)

Clears the data sheet level/order columns

Sub API_BCC_EI_ClearResultMessages(ByRef pWorkbook As Workbook)

Clears the data sheet result messages

Sub API_BCC_EI_ClearDataArea(ByRef pWorkbook As Workbook)

Clears the data sheet data area

Sub API_BCC_EI_SetConfig(ByRef pWorkbook As Workbook, ByVal pParam As String, ByVal pValue As String)

Sets the chosen configuration setting.

WARNING: This procedure does not check the passed value in any way! The programmer must ensure, that the passed value is correct.

pParam – depicts the configuration parameter to be set

pValue is the passed parameter value

Function API_BCC_EI_GetConfig(ByRef pWorkbook As Workbook, ByVal pParam As String) As String

Gets the chosen configuration setting.

pParam – depicts the configuration parameter to be set

Sub API_BCC_EI_SetALO(ByRef pWorkbook As Workbook)

Fills level/order columns on the data worksheet.

Function API_BCC_EI_getLastDataSheetRow(ByRef pWorkbook As Workbook) As Long

Returns last row on the data sheet

Sub API_BCC_EI_SetSAPUser(ByRef pWorkbook As Workbook, ByVal pUser As String)

Sets SAP user ID for script calling (if not set, then on execution a popup window will appear to ask for user ID)

Sub API_BCC_EI_SetSAPPass(ByRef pWorkbook As Workbook, ByVal pPass As String)

Sets SAP password for script calling (if not set, then on execution a popup window will appear to ask for password). Password will be stored only for the amount of time set in general settings. Password can be deleted by calling this function again with an empty string as password. 

GetConfig/SetConfig pParam most important values (for full list see EI_Config worksheet, column A):

•          DS_START       - data sheet start row (number >=10)

•          DS_END         - data sheet end row (optional, number >=11)

•          PREV_DOUBLE    - prevent double posting (X)

•          BACKUP_BEFORE  - save backup data sheet before script start (X)

•          BACKUP_AFTER   - save backup data sheet after script end (X)

•          DEBUG_DET_MESG - debug mode detailed messages (X)

•          SKIP_IND       - character used as skip indicator (skipped if put on data sheet, can be left empty)

•          SKIP_DELTA     - setting telling that the skip indicator will be used, or all values will be transfered (X)

•          WAIT_TIME      - wait time between consecutive transaction call (used sometimes to slow down the EI) (number in ms)

•          SUBLEVEL_REQUIRED - setting telling whether the sublevel (level more than 0) is required e.g. for FI documents (X)

•          SAP_GUI_USE    - setting telling whether SAP_GUI should be used for the script (needed for some transactions) (X)

•          LOOP_BACK      - setting telling that loops over sublevels should be done backwards (useful for some transaction scripts) (X)

•          AUTO_LEVEL_ORDER - auto recognition of data lines (about setting of level/order) (X)

•          MESSAGE_TYPES_PRESENTED   - message types that should be presented on data sheet (*=ALL, string e.g. AESIW)

•          MESSAGE_VALUE_READ_STRING - string to get value from the message back (ID-Nr-Param-Column)

•          RESULT_CHECK_STRING       - setting telling how result checking is verified (E|S-Type[-Id][-Nr])

•          CONFIG_PASS    - string for config pass (can be left emty)