Help with COM object in SAP

[TerryBell]

I am new to COM objects but think I have a general idea of what is required, however, SAP has me stumped (I've read the docs on this site and others).

As of right now I can't even do the basic task of getting the attention of the SAP Script Engine. I do have a vbs script as an example that does work so here is what I have so far:

vbs:

Set SapGuiAuto = GetObject("SAPGUI")

Set application = SapGuiAuto.GetScriptingEngine

my AutoIt conversion:

$SapGuiAuto = ObjGet("","SAPGUI")

$application=$SapGuiAuto.GetScriptingEngine

When I run the vbs I get a SAP warning box from the SAP GUI saying that a script wants to run. This is what should happen.

When I run the AutoIt I get an AutoIt Error box with the follow:

$application=$SapGuiAuto.GetScriptingEngine

$application=$SapGuiAuto^ERROR

Error: Variable must be of type "Object"

In my very limited understanding it looks like vbs is able to find the SAPGUI COM object but AutoIt can't. I have ran the error trap on the AutoIt code and as far as AutoIt is concerned it is not an object.

I would applicate any help pointing me in the right direction.

[DaleHohm]

It is possible that SAPGUI does not support the IDispatch interface. Please read the Obj/COM Reference section in the helpfile. In particular, work through the OLE/COM Object Viewer to investigate SAPGUI to see if IDispatch is available.

Dale

Edit: BTW, your syntax conversion to AutoIt looks correct. Also, for grins I would try $SapGuiAuto = ObjCreate("SAPGUI") to see if it created an abject, but I would not expect it to.

Edited January 25, 2007 by DaleHohm

[TerryBell]

It is possible that SAPGUI does not support the IDispatch interface. Please read the Obj/COM Reference section in the helpfile. In particular, work through the OLE/COM Object Viewer to investigate SAPGUI to see if IDispatch is available.

Thanks Dale.

OK,

I there are tons of SAP Objects in the OLE viewer so when I went to look at this the first time I could never find it. I did a text search on GetScriptingEngine in the SAP directory and found that it is in sapfewse.ocx aka SAP Scripting Control in the OLE viewer.

The program ID is Sapgui.ScriptingCtrl.1 which was not what I was looking for the first time around.

The point of all of this is that Sapgui.ScriptingCtrl.1 does not have a VersionIndependentProgID so I'm dead in the water with AutoIt v3 (get to learn some vbs).

For posterity sake, I'm using 6.2 of the SAP GUI. I know that sapfewse.ocx was updated with 6.4 of the SAP GUI so while it seems AutoIt does not work with 6.2 I don't know about 6.4.

[DaleHohm]

Does Sapgui.ScriptingCtrl.1 expose IDispatch? You are not forced to use the VersionIndependentProgID.

Dale

[TerryBell]

Does Sapgui.ScriptingCtrl.1 expose IDispatch? You are not forced to use the VersionIndependentProgID.

Yes it does. You are making me think that there is hope.

[DaleHohm]

Yes it does. You are making me think that there is hope.

Try

$SapGuiAuto = ObjGet("","Sapgui.ScriptingCtrl.1") 
$application=$SapGuiAuto.GetScriptingEngine

Dale

[TerryBell]

Try

$SapGuiAuto = ObjGet("","Sapgui.ScriptingCtrl.1") 
$application=$SapGuiAuto.GetScriptingEngine

It didn't work. I also tried ObjCreate for fun and that did not work either.

If it helps, I tried this vbs (remember I don't know vbs so I don't know if the syntax is right):

Set SapGuiAuto = GetObject("Sapgui.ScriptingCtrl.1")

Set application = SapGuiAuto.GetScriptingEngine

That did not work either.

[DaleHohm]

It didn't work. I also tried ObjCreate for fun and that did not work either.

If it helps, I tried this vbs (remember I don't know vbs so I don't know if the syntax is right):

Set SapGuiAuto = GetObject("Sapgui.ScriptingCtrl.1")

Set application = SapGuiAuto.GetScriptingEngine

That did not work either.

Quick search found this: https://forums.sdn.sap.com/thread.jspa?mess...173&#536173

It suggests the following VBS syntax:

Set Wrp = CreateObject ("SapROTWr.SapROTWrapper")
Set SapGui = Wrp.GetROTEntry ("SAPGUI")
Set application = sapgui.GetScriptingEngine

ROT is the Running Object Table and is where active COM objects are registered.

The AutoIt syntax for this would be:

$Wrp = ObjCreate("SapROTWr.SapROTWrapper")
$SapGui = $Wrp.GetROTEntry ("SAPGUI")
$application = $SapGui.GetScriptingEngine

There is also a pointer in that Forum to a detailed programming document...

Dale

[TerryBell]

OK Dale,

Talk about going above and beyond.

This works in SAP GUI 6.40 but not 6.20 (I just got done upgrading).

Now I can make SAP bend to the will of Autoit

Thanks again for all of your help. I hope one day I can give back.

Tb

[lod3n]

@TerryBell, if you come up with anything interesting, please post it. I am curious to see some useful AutoIt code for SAP.

[DaleHohm]

OK Dale,

Talk about going above and beyond.

This works in SAP GUI 6.40 but not 6.20 (I just got done upgrading).

Now I can make SAP bend to the will of Autoit

Thanks again for all of your help. I hope one day I can give back.

Tb

Cool, glad it worked.

Dale

[dworld]

Hi,

I know that it is an old thread, but I'll give a try:

this is not working for me

$Wrp = ObjCreate("SapROTWr.SapROTWrapper")
$SapGui = $Wrp.GetROTEntry ("SAPGUI")
$application = $SapGui.GetScriptingEngine

My AutoIt version is 3.2.13.0

I'm using SAP Logon 710 and i added my .exe in the SAP Konfiguration.

Thank you for the help in advance

[TerryBell]

Are you logged into a session?

Do you have user scrips enabled under the Client's options?

These are the two reasons I usually see that error.

[seangriffin]

$application=$SapGuiAuto.GetScriptingEngine

$application=$SapGuiAuto^ERROR

Error: Variable must be of type "Object"

Yes I get this error when I try to run my SAP scripts from home, because my home computer does not have the SAP GUI client installed.

At work, these commands work because that computer has SAP GUI Release 6.40 installed, and at installation time the SAP Scripting COM object is registered with Windows ( a requirement to get those statements to work).

Make sure you have the SAP GUI client installed on your computer.

Edited December 23, 2008 by seangriffin

[LittleMickey74]

Hello, a long time has passed, but as I found this thread someone else will so ... here is what I am using:

 

$SAPROT = ObjCreate("SapROTWr.SAPROTWrapper")
$GuiAuto = $SAPROT.GetROTEntry("SAPGUI")
$application = $GuiAuto.GetScriptingEngine()
$connection = $application.Children(0)
$session = $connection.children(0)

So, here is an explanation (please correct me if I was wrong):

- Create the object from the library (registered DLL):

$SAPROT = ObjCreate("SapROTWr.SAPROTWrapper")

- Here, we will connect to the "SAP Login" or "SAP Login Pad":

$GuiAuto = $SAPROT.GetROTEntry("SAPGUI")

- I guess, make a connection to the SAP GUI Scripting engine:

$application = $GuiAuto.GetScriptingEngine()

- This is a connection to the server, if you have several OPENED, then you can choose the correct one:

$connection = $application.Children(0)

- And finally, make a connection to the session (windows) from that connection, max 6 sessions per connection:

$session = $connection.children(0)

 

Hope this helps, all of those are OBJECTS, so something like:

If Not IsObj($SAPROT) Then

should be used.

 

Hope this helps