Learn how to a build a cloud-first strategyRegister Now


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

Posted on 2014-08-09
Medium Priority
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
  • 2
LVL 75

Expert Comment

by:käµfm³d 👽
ID: 40251487
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:  http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_26450356.html

Accepted Solution

mannevenu26 earned 0 total points
ID: 40251519
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

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

thank you :)

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction Hi all and welcome to my first article on Experts Exchange. A while ago, someone asked me if i could do some tutorials on object oriented programming. I decided to do them on C#. Now you may ask me, why's that? Well, one of the re…
While working on Silverlight and WCF application, I faced one issue where fault exception occurred at WCF operation contract is not getting propagated to Silverlight client. So after searching net I came to know that it was behavior by default for s…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Suggested Courses
Course of the Month21 days, 6 hours left to enroll

810 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