Reading Excel Cell values using VB script

[GirieshM]

Hi All,

I am currently try to work on a blog where its aim to input the values from excel and based on the values it has to get the values from DB in sap and display it in the Output portion of the excel as mentioned in the following blog http://scn.sap.com/docs/DOC-31015. I have created the FM and done the basic things mentioned in the blog but I am facing an error "Run Tme Error '40036' Application-defined or object-defined error". Please find my code below and help to resolve the issue.

With Regards,

Giriesh M

[holger_khn]

Hello.

As far as I see you have your code in Sheet1.

I suggest to move this code into Module1. Then I guess you will not get any runtime error.

[Former Member]

Dear Holger,

From the 1st screenshot, it seems that the codes are already in Module1. Am referring to the VBE Titlebar and Watches Pane.

Thanks,

Sayuti