Solved

call web services from excel 2007

Posted on 2010-08-23
2
1,568 Views
Last Modified: 2013-11-10
I have this store procedure
alter PROCEDURE padron.BuscarPorNumeroDocumento
@numdle nchar(16)
as
select PDR.NUMDLE, PDR.APEPAT, PDR.APEMAT, PDR.NOMBRE
from   padron.padron_20091121 PDR
      INNER JOIN padron.ubigeo_20091121 UBI
      ON PDR.coddep=UBI.coddep
            and PDR.codpro=UBI.codpro
                            and PDR.coddis=UBI.coddis
where PDR.NUMDLE = @numdle

I want to consume it from an excel sheet, that's why I created a project such as Excel 2007 Workbook, I can not find much information, what I could do is:
http://social.msdn.microsoft.com/Forums/en-US/vsto/thread/fd918ad1-716d-4f9e-a1e8-3ac606e7f4d9
1. Create a new VSTO2005 Excel Workbook project
2. Add a web service reference to the project pointing to the web service that returns the dataset.
3. Using the Data Sources window, add the resultant dataset to your sheet as a data source.
4. From the data sources window, drag and drop the table in the dataset onto the worksheet as a ListObject.

I did all the steps.
TexBox and I have the button, my question is: what should be the code for the button to
1. capture the value q is entered textbox
2. with that value to call the web service
3. display the results in excel

I am using  Visual Studio 2008 nd Office 2007
buttonCODE.jpg
excelo2.jpg
excel01.jpg
0
Comment
Question by:enrique_aeo
2 Comments
 

Author Comment

by:enrique_aeo
ID: 33512065
sr experts help me in this problem, need more information?
0
 
LVL 19

Accepted Solution

by:
Amandeep Singh Bhullar earned 500 total points
ID: 33518635
Check the links

http://msdn.microsoft.com/en-us/library/dd819156%28office.12%29.aspx
http://stackoverflow.com/questions/474936/call-web-service-in-excel

Hope the links will help you solve the issue of excel connectivity with wen service
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

For a while now I'v been searching for a circular progress control, much like the one you get when first starting your Silverlight application. I found a couple that were written in WPF and there were a few written in Silverlight, but all appeared o…
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

803 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