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
