Implement Variables onto VBScript

Help Activities
, , ,
1

Hi All, I’m currently creating a small data extraction bot with SAP. I created the following variables in Studio via Activity Input Dialog - SelectedDate , SelectedMonth, & SelectedYear. I did a script record and am now trying to implement the variables in the VBscript, but having trouble. Anyone know I can implement the variables created in Studio onto the following VBscript to replace “11.01.2023”? The code follows:

If Not IsObject(application) Then
Set SapGuiAuto = GetObject(“SAPGUI”)
Set application = SapGuiAuto.GetScriptingEngine
End If
If Not IsObject(connection) Then
Set connection = application.Children(0)
End If
If Not IsObject(session) Then
Set session = connection.Children(0)
End If
If IsObject(WScript) Then
WScript.ConnectObject session, “on”
WScript.ConnectObject application, “on”
End If
session.findById(“wnd[0]”).maximize
session.findById(“wnd[0]/usr/cntlIMAGE_CONTAINER/shellcont/shell/shellcont[0]/shell”).selectedNode = “F00002”
session.findById(“wnd[0]/usr/cntlIMAGE_CONTAINER/shellcont/shell/shellcont[0]/shell”).doubleClickNode “F00002”
session.findById(“wnd[0]/usr/ctxtFKDAT-LOW”).text = “11.01.2023”

2

Hi,

You need to write above code in a function and pass variable to that function as a variable:

function(your_variable)
{
your code
e.g. Set SapGuiAuto = GetObject(your_variable)
}

pls mark it as solution if this solves your issue

Thanks

3 Likes