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

Posted on 2014-08-09
Last Modified: 2014-08-22

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....
Question by:mannevenu26
    LVL 74

    Expert Comment

    by:käµfm³d 👽
    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:

    Accepted Solution

    what u have send that is one time of approach,but iam using different approach.we need to follow this approach

    I had one excel vba macro sheet iam connecting through the soapclient.iam adding MSSOAP30.dll to referrence.

    could you please help me in this regards.

    Author Closing Comment

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

    thank you :)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Suggested Solutions

    This article describes a simple method to resize a control at runtime.  It includes ready-to-use source code and a complete sample demonstration application.  We'll also talk about C# Extension Methods. Introduction In one of my applications…
    This article is for Object-Oriented Programming (OOP) beginners. An Interface contains declarations of events, indexers, methods and/or properties. Any class which implements the Interface should provide the concrete implementation for each Inter…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now