I have an Excel 2003 "application" that at this time the users refuse to part with. I am updating it to use a .NET class library for some of the calculation, to try to minimize the risk of using excel. This .NET Class Library calls a .NET WCF Web Service.
When trying to call a function that utilizes the web service, the class library throws an InvalidOperationException. I know that when the calling application is in .NET, the solution to this problem is to copy the values to the app.config file. SO Solution
However, since I'm calling it from excel, I'm not sure of a way to specify the endpoint information.
The error probably isn't important, since I already know the solution, but here it is for completeness:
Could not find default endpoint element that references contract 'GasPurchases.IGasPurchases' in the ServiceModel client configuration section. This might be because no configuration file was found for your application, or because no endpoint element matching this contract could be found in the client element.