Garret,
I solved the previous problem by sending the value of each field individually, but I am now running into the same problem because to get values back I need to pass a variable by reference.
Sergey has given me a KB reference: ActiveX Controls Passing Variant* Back to VFP Cause Error mskb #
Q177575.
Can you share the VB code you used as an intermediary, or better yet some C code that doesn't require an additional runtime module?
Thank you very much.
Alex
>>I need to send an array of variants to an olecontrol and
>>am getting an error. I do it this way but am getting an
>>error. What could it be? TIA, Alex
>>
>
>* Intellisense for GetArray indicates:
>* GetArray(ColLeft AS Number,RowTop AS Number, VarArray AS Variant) AS Logical
>DIMENSION Thisform.aSheet[15,15]
>ACOPY(Thisform.aSheet,laSheet)
>llStatus = Thisform.oSheet.GetArray(1,1,@laSheet)
>
>Alejandro, last time I needed to do something like this, I ended up writing code in VB to call the object, and then calling the VB DLL from VFP. I couldn't find any way to explain to the object what kind of array VFP was passing it.
>
>Is there any way you can get that array returned to VFP, modify it, and pass it back into the function call?