Connect SAP on Citrix through Excel VBA

excel vba sap-gui
user7383845 picture user7383845 · Jan 9, 2017 · Viewed 14k times · Source

I have no direct SAP installed on my machine and using SAP window through below link.

https://nedc-ctx.applications.services.axa-tech.intraxa/Citrix/AccessPlatform/auth/loggedout.aspx

I am aware of Record and Run function of SAP GUI and that is working. I have this access in training version only. In production I am unable to use run and record option.

How do I open SAP window from Excel VBA, connect and load the data?

In code below I get an error.

I found I am unable to add reference file "sapfewse.ocx" on my machine.

Is it possible to connect SAP through Excel VBA if we access SAP through above provided link. After clicking on above link new pop-up window will get connected with SAP with window. SAP is getting connected through Citrix.

Code (taken from this help link):

Set SapGuiAuto  = GetObject("SAPGUI") 'Get the SAP GUI Scripting object
Set SAPApp = SapGuiAuto.GetScriptingEngine 'Get the currently running SAP GUI 
Set SAPCon = SAPApp.Children(0) 'Get the first system that is currently connected
Set session = SAPCon.Children(0) 'Get the first session (window) on that connection

'Start the transaction to view a table
session.StartTransaction "SE16"

Answer

JoseS picture JoseS · Jan 9, 2017

The code you provided would only work if you have the SAP GUI installed on your computer. I would suggest asking the IT team if they can provide you the server address so you can use a Remote Function Call to retrieve the data automatically. This can be done with VBA (https://archive.sap.com/discussions/thread/129358) You would need to adapt the code in the link to match your needs

Related questions

How to run SAP GUI script from Excel Macro

I am trying to create a Excel macro which executes the SAP GUI Script. I already created the script but I didn't understand how to use that in VBA macro. This is my SAP GUI Script : If Not IsObject(application) …

Read More
SAP GUI script: read table or data from ALV Grid

I'm currently creating an automation script where data from excel will be searched in SAP table. I tried to record the steps in SAP but it only gives me this: session.findById("wnd[0]").maximize session.findById("wnd[0]/usr/lbl[18,15]").setFocus …

Read More
Is there a way to crack the password on an Excel VBA Project?

I've been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there's a lack of documentation... no-one knows the passwords. Is there a way of removing or cracking the password on a VBA …

Read More