Consuming Web Service from Access VBA (Type MisMatch Error)

[Ayoa]

I am attempting to call a web service from Access 2003 (using the built-in
web services reference tool). The web service should return an array of
integers.

Example web method (C#)

[WebMethod]
public int[] GetIntArray()
{
int[] a = new int[5];
for (int i = 0; i < 5; i++)
a = i * 10;
return a;
}

However at the client side (Access VBA) I am getting the Type Mismatch
error.
This is the function (auto-generated by the web services reference tool ) in
VBA that gives the error.

Public Function wsm_GetIntArray() As Variant
'Error Trap
On Error GoTo wsm_GetIntArrayTrap

wsm_GetIntArray = sc_GuidelinesService.GetIntArray()

Exit Function
wsm_GetIntArrayTrap:
GuidelinesServiceErrorHandler "wsm_GetIntArray"
End Function

When i call my web method from a c# client, it works Ok.

Any suggestion how how to fix this is welcome?

 

[Albert D.Kallal]

Kind of funny you post your c# code. And, you even post the code generated
by the VBA web add-in.

However, you forget to post your few lines of code that fails? (am I missing
something here???).

Anyway.....

What does the few lines of code that calls the GetIntArray in VBA look like?
Notice that the "type" returned for that function is a variant. So, while it
is called GetIntArrary, perhaps the variant type is still string, or even a
"long" data type....