hi,
I am trying to call a WCF service from Excel VBA. I do not want to
rely on anything installed on client machine apart from my Excel
spreadsheet so I wanted to use the MEX method of invoking as explained
here: http://msdn.microsoft.com/en-us/library/ms752245.aspx
This works fine if all parameters and return values are basic types
but it is not obvious to me what needs to be done if I want to use a
custom type. I currently get a 80131509 error when calling a service
which has a custom type. I have marked the custom type as a
DataContract with its properties as DataMember. Just the inclusion of
this in the contract means that a call to the service (even a method
that does not involve the custom type) results is the aforementioned
error. Do I need to put something else in the config file with regard
to the data contract?
I am hoping I do not have to put anything else on the client side
other than the vba code.....
thanks
Phil
I am trying to call a WCF service from Excel VBA. I do not want to
rely on anything installed on client machine apart from my Excel
spreadsheet so I wanted to use the MEX method of invoking as explained
here: http://msdn.microsoft.com/en-us/library/ms752245.aspx
This works fine if all parameters and return values are basic types
but it is not obvious to me what needs to be done if I want to use a
custom type. I currently get a 80131509 error when calling a service
which has a custom type. I have marked the custom type as a
DataContract with its properties as DataMember. Just the inclusion of
this in the contract means that a call to the service (even a method
that does not involve the custom type) results is the aforementioned
error. Do I need to put something else in the config file with regard
to the data contract?
I am hoping I do not have to put anything else on the client side
other than the vba code.....
thanks
Phil