I've been using the SAP ScriptRecording functionality to automatically copy data from an excel spreadsheet into SAP transaction.
Excel used: v2007
SAP : R/3
It's all been going good until recently I've taken a project to do the same on an SAP that is on Citrix.
Although the SAP Scripting functionality is valid, there is an error prompted when I'm using the standard code to make the connection to SAP.( this code is generated when I'm using the Record Scripting and I'm just copying it into Excel VBE and try to run it
If Not IsObject(Application) Then
Set SapGuiAuto = GetObject("SAPGUI")
Set Application = SapGuiAuto.GetScriptingEngine
If Not IsObject(Connection) Then
Set Connection = Application.Children(0)
If Not IsObject(session) Then
Set session = Connection.Children(0)
If IsObject(WScript) Then
WScript.ConnectObject session, "on"
WScript.ConnectObject Application, "on"
the error that I'm getting is "Compile Error ; Invalid use of property " and the 3rd line is highlighted;
this is very strange because on my local computer it working perfectly and no error is generated ;
I tried everything I knew: even manually added the references that we're selected on my computer on the Citrix computer:
" Microsoft ActiveX Data Objects 2.8 Library"
" Microsoft ActiveX Data Objects RecordSet 2.8 Library"
"iextag 1.o Type Library"
but the error stays there.
could someone give me some advices what to try more?