VBA vs SAP

pyrohac · Oct 25th 2012

hi all,

i have hopefully a simple question for you.

I am logged into sap and want to write a vba code, that will run a new function in sap under my current login (it means with no need of any password or username...).

Is it possible?

Thank you

xposted:http://www.mrexcel.com/forum/excel-q...ns-vs-sap.html and http://www.excelforum.com/excel-prog...ba-vs-sap.html

Kyle123 · Oct 25th 2012

Re: VBA vs SAP

xposted: http://www.mrexcel.com/forum/e…-applications-vs-sap.html and http://www.excelforum.com/exce…os/871200-vba-vs-sap.html,

AAE · Oct 25th 2012

Re: VBA vs SAP

pyrohac,

Per the rules you agreed to abide by (you read them, right?) you are required to provide links to all other forums where you have cross posted the same question.

Please click on "[COLOR="#FF0000"]Message to Cross Poster[/COLOR]" in my signature and read in full to understand why [COLOR="#0000CD"]violating this rule is the quickest way to having your posting rights revoked[/COLOR]. All Excel forums have this same rule, for good reason.

Please update your thread to include links to *ALL* cross posts.

pyrohac · Oct 26th 2012

Re: VBA vs SAP

Hi all,

i have already solved this issue, maybe it will help someone:

Code

Set SapGuiAuto = GetObject("SAPGUI")
Set SAP = SapGuiAuto.GetScriptingEngine
With SAP.Connections(0).Sessions(0)
    .createsession
    .StartTransaction ("SAP FUNCTION")
End With

VBA vs SAP

Participate now!

Share