Does anyone know how to dimension a blank array like in vb. Basically I need this:

Dim VBArray()

To be initialized in OpenInsight. Thanks, any help is appreciated.

You mean like

pre.code {

 background-color: #E5E5E5;

 border: 1px solid #000000;

 width: 450px;

 padding: 5px;

 font-family: courier, verdana, arial, serif;

 margin: 0px 10px auto;

}

DIM VBArray( 100 )
Mat VBArray='

The Sprezzatura Group

World leaders in all things RevSoft

Check Dimension in the help.

I keep getting a "Variable has been dimensioned and used without subscripts" error. The code:

OOApp=OleCreateInstance("com.sun.star.ServiceManager")

desk=OOApp-]CreateInstance( "com.sun.star.frame.Desktop")

Dim VBArray(100)

MAT VBArray='

Doc=OleCallMethod(desk,'loadComponentFromURL',"private:factory/scalc","_blank",0,VBArray)

I tried this in another piece of converted VB code and could not find an answer. It may be that passing an array through oleCallMethod is not possible. If anyone has a solution I would also like to know.

Thanks,

John

I doubt whether the OLE object is aware of the Dimensioned array constructs from OpenInsight. You might have to create these as a string of Char(0) but you would need to know the size of the array from the VB side. Just a guess.

Any suggestions from revelation?

Hi Clay.

I think you need to make a 'helper' function which accepts a string and a delimiter uses the VB Split function to return an array. You could ewrite it in VB. If you look up windows scripting components ( .WSC files ), I think you'll find that you could oswrite a scripting component file, register it, then use it as a com component with OleCreateInstance. Another approach is to Create and instance of the Windoes scripting host Using OLECreateInstance, then use AddFunction to add a function that creates the arrays and calls our deired function, returning the result.

The following looked interesting too.

http://support.microsoft.com/kb/q250344/

hth

Bob

Thanks Bob, I will try that.

Has anyone found an easy way to create a VB array in OI?

I need to pass a variant array to the oleCallMethod.

I'm hoping that this has been long solved and someone is willing to share.

Thanks,

John

Has anyone found an easy way to create a VB array in OI?

I need to pass a variant array to the oleCallMethod.

I'm hoping that this has been long solved and someone is willing to share.

Thanks,

John

View this thread on the Works forum...