CODEWITHSUNDEEP
excelvbasap-gui
Sukhi
Sukhi

Reputation: 14215

Excel VBA with SAP GUI 7.40 - SAP.Functions not working

I have a Excel VBA which connects to SAP GUI, 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

Set obBAPICall = CreateObject("SAP.Functions")

I get following error :

Run-time error '-2147024770 (8007007e)':

Automation error
The specified module could not be found. enter image description here

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).

enter image description here

My SAP GUI version is :

enter image description here

Any help is highly appreciated.

Thank you.

Edit : Following code does not have any problem :

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

Upvotes: 2

Views: 4829

Answers (1)

Sukhi
Sukhi

Reputation: 14215

Got it ! The problem was with the latest MS office product (and not with SAP GUI 7.40). The IT guys had rolled out some updates in MS Office and it was creating a problem. I restored MS Office and it is working fine now.

Upvotes: 1

Related Questions