SAPGui Scripting from VBA

Former Member — Wed, 22 Oct 2008 16:49:13 GMT

Hi,

I am creating a macro in Excel which would load asset data through SAPGui Scripting but I am running into a very strange problem.

In order to be sure that the data get's loaded to correct system I have created inputbox where all the open systems are listed and the user should select one by entering a corresponding number. (it's the number of connection object in Application.Connections collection) When this number is used as a variable in

Set App = SapGuiAuto.GetScriptingEngine

...

Dim I

I = InputBox(ItemText, "Select open system", 0)

Set Connection = App.Children(I)

Then the system returns following message:

Run time error '618'

Bad index type for collection access

Anybody has any ideas what might be wrong?

Re: SAPGui Scripting from VBA

Former Member — Thu, 08 Aug 2013 07:53:28 GMT

Hi Peeter Parelo:

Please try the following:

...

'Dim I

I = InputBox(ItemText, "Select open system", 0)

Set Connection = App.Children(int(I))

...

end sub

Question Re: SAPGui Scripting from VBA in Additional Q&A

SAPGui Scripting from VBA

Re: SAPGui Scripting from VBA