Skip to Content
0
Former Member
Jun 27, 2016 at 12:56 PM

Excel VBA (SAP.Functions) Not working with SAP GUI 7.40

2879 Views

have a Excel VBA which connects to SAP, pulls some data and does some processing on it. It was working fine with SAP GUI 7.20. But it stopped working when I installed SAP GUI 7.40. My code is as below :

Dim obBAPICall As Object  ' * Create object Set obBAPICall = CreateObject("SAP.Functions") . .

I get following error :

I've already gone through some weblinks and I believe I've all the required references. (In fact, I've added many more in order to troubleshoot the problem).

My SAP GUI version is :



For your information -

Following code does not have any problem :

Set SAPguiApp = CreateObject("Sapgui.ScriptingCtrl.1")

Any help is highly appreciated.

Thank you.

Attachments

1.png (23.6 kB)
3.png (10.4 kB)
2.png (50.9 kB)