Skip to Content
Former Member
Dec 24, 2012 at 11:57 AM

SAP ScriptRecoding - transfer data from Excel SAP


hello forum,

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

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


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?

thank you,



Untitled.png (273.9 kB)