<div>
I think you would have an easier time writing a wrapper library for your WCF service in .NET, and then import that library into your Excel project. With the .NET project you can use the &quot;Add Service Reference&quot; menu options to easily create proxy classes for your WCF service. Then it's simply a matter of exposing the appropriate functionality to Excel.<br />
<br />
I participated in a question some time ago that dealt with importing .NET code into Excel. You can find that discussion here: &nbsp;<a href="https://www.experts-exchange.com/questions/26450356/How-to-use-net-framework-regex-in-Excel.html" rel="ugc">https://www.experts-exchange.com/questions/26450356/How-to-use-net-framework-regex-in-Excel.html</a>
</div>


I think you would have an easier time writing a wrapper library for your WCF service in .NET, and then import that library into your Excel project. With the .NET project you can use the "Add Service Reference" menu options to easily create proxy classes for your WCF service. Then it's simply a matter of exposing the appropriate functionality to Excel.

I participated in a question some time ago that dealt with importing .NET code into Excel. You can find that discussion here:  https://www.experts-exchange.com/questions/26450356/How-to-use-net-framework-regex-in-Excel.html [https://www.experts-exchange.com/questions/26450356/How-to-use-net-framework-regex-in-Excel.html]

<div>
i did not get correct answer so i am closing my question.<br />
<br />
thank you :)
</div>


i did not get correct answer so i am closing my question.

thank you :)

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
Actually iam face one problem that is....<br />
i need to call my WCF service url to my excel vba macro.i dont know how to call the wcf service url to vba excel mcaro .<br />
how many &nbsp;type of ways can be connected to excel macro.<br />
<br />
could you please help me regarding on this....
</div>
</div>


Hi,

Actually iam face one problem that is....
i need to call my WCF service url to my excel vba macro.i dont know how to call the wcf service url to vba excel mcaro .
how many  type of ways can be connected to excel macro.

could you please help me regarding on this....

how to call wcf service url to my Excel vba macro 2010,2012

Windows Communication Foundation (WCF) is a tool used to implement and deploy a service-oriented architecture (SOA) to support distributed computing where services have remote consumers. It features a runtime and a set of APIs in the .NET Framework for building connected, service-oriented applications. Services typically have a WSDL interface (Web Services Description Language) that any WCF client can use to consume the service, regardless of which platform the service is hosted on. WCF implements many advanced Web services (WS) standards such as WS-Addressing, WS-ReliableMessaging, WS-Security, RSS Syndication Services, WS-Discovery, routing and better support for REST services.

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).