Hi, I'm looking for a piece of code which ... on Yedda

Hi, I'm looking for a piece of code which ...

Hi, I'm looking for a piece of code which implements a call to a web service from Microsoft Excel (using VBA).

My intention is to apply a URL with parameters and to receive XML string from the web service so i can analyze it.

(The web service is already implemented, and approached by sending URL with parameters. It's not in UDDI etc.)

Thanks, Nir.

Posted Answers

Eran

425 answers

520 thumbs up

They're coming to take me away, Ha-haaa!

Advanced .NET Debugging Blog

My personal blog

Hi Nir,

Generally speaking, if you want to use VBA to execute a web services call you'll need to use the SOAP Toolkit (which is phasing out). You have to do that because VBA uses Visual Basic 6 like features (COM and friends) and not uses .NET.

I've found this example (with code) that shows how to do it. Just click on the "VBA Code to call the Web Service" link and it will expand the page to show you the code.

Another way of doing that without using the SOAP Toolkit is to write a .NET object that performs the call and exposes itself as a COM object. Then you can simply add a reference to it from your VBA code and call it.

Posted 2 years ago ( permalink )

In reply to Nir's question

Eran was invited by Yedda to answer this question.

Rated as
#1 out of 1

Report Abuse

Helpful?

Sign in to participate

Got an answer for Nir? Would you like to comment on the posted answers, or vote for the one which you think is the best?

Explore Related Questions

Other people asked questions on similar topics, check out the answers they received:

What is XML ?

what is XML ?

Submitted by atyachin 2 years ago

1 answer
viewed 445 times

Last answer posted 2 years ago by dudushmaya

What is XML

what is XML

Submitted by amiodezky 2 years ago

1 answer
viewed 513 times

Last answer posted 2 years ago by mor

XML versus HTML

When will XML completely replace HTML in web pages?

Submitted by Elad 2 years ago

4 answers
viewed 658 times

Last answer posted 3 months ago by Jewelry Website

» More...

Explore Related Posts in Forums

VBA Excel/Word using XMLHTTPRequest

Are there any S3 examples using the COM xmlhttprequest functionality available within Excel/Word VBA ? Having the ability to send and receive data via S3 from an MS Office macro would be very useful.

Writing to ms excel

to write data to excel cells (or to be more specific to an .xls file), let's say for the sake of argument service. It goes into the cocoon pileline, and is first turned into XML. Then...

making a web service call from excel 2000 in vba

Hello, I need to send out a webservice call from VBA in excel 2000...that looks like this...>&gt of xml that I will need to parse...once I get the page in to excel I can do everything else. I'm just

» More...

Feed - Subscribe to changes to this Q&A Blog

Explore Related Videos

Dissecting DB2 with Julian Stuhler

President of IDUG and Principal Consultant at Triton Julian Stuhler addresses DB2's ease of use, compression capabilities, and his experiences working with IDUG.

Web 2.0 ... The Machine is Us/ing Us

This is the famous "web 2.0 in under 5 minutes" video created by Viddler user mwesch. I have simply used Viddler's 500mb upload allowance to upload a higher quality version of the video (compare to the YouTube version http://www.youtube.com/watch?v=6gmP4n k0EOE ) Be sure to add it to you favorites if you enjoyed it! Also, visit http://theclosetentrepreneur.com/michael-weschs-web-20-the-machine-is-using-us-video ...for more info about the movie and the embed code that will keep the video from distorting when embedded on a site or in a blog post.

Control XML = Successful SOA

If you've got services, you've got XML, according to Reactivity's Joelle Gropper Kaufman. In fact, your network may be invaded by it. It's a problem because XML requires a lot of processing and is inherently insecure. Find out how to gain control of XML at the network level, so you can build more services and connect with more business partners.

MindTouch Deki Data Services

MindTouch DekiWiki is an open source wiki engine and web framework for enterprise and social applications. This video showcases the new Live Data Services, which make it relatively easy to extend the DekiWiki with webservice exposed applications, widgets, or external data stores. UPDATE: we're calling this "Extensions" now. One provides the URL to the webservice and a description in the services manager control panel. Pretty simple stuff.

MindTouch DekiWiki 'Hayes' Architecture...

MindTouch DekiWiki is an open source wiki engine and web framework for enterprise and social applications. This video is a high level look DekiWiki's architecture.

MindTouch: Introduction to REST

This video is a brief summary of REST. What is REST? REST is a term coined by Roy Fielding in his Ph.D. dissertation to describe an architecture style of networked systems. REST is an acronym standing for Representational State Transfer. http://www.restpatterns.org/

ANI XML make tutorial

Tutorial on how to make a xml with the ani xml maker , the program is made by X enterprises

WordCamp 07: 'The past, present, and future...

Using a make-shift video to laptop setup that, didn't end up working out all that well, I was able to capture some video from WordCamp 2007. Dave Winer's session on " The past, present, and future of Web publishing " was very informative. He presented it "blog style" where he would suggest a topic and ask for feedback. Note: Feel free to time tag this for me... as I'm still compressing and uploading more video!

MindTouch SODA: Service-Oriented...

MindTouch DekiWiki is an open source wiki engine and web framework for enterprise and social applications. This video explains the concept of a Service Oriented Distributed Architecture (SODA), which is, in short, a system of federated user agents. Also, it briefly touches on Document Orietented Programming (DOP) a RESTFul programming pattern.

RSS In Plain English by Common Craft

This is hands down the best description of feeds and feed readers that I've seen. It's brought to you by the fellas at Common Craft http://www.commoncraft.com

Resolved question