Web Services in Excel 2007

Hi experts, i am reading about Consuming Web Services in Excel 2007,
i find this URL http://msdn.microsoft.com/es-es/library/dd819156(v=office.12).aspx 
but does not work. i attached the error. Do you know other thr url? or something resources
webserviceDOESNOTfound.jpg
enrique_aeoAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Richard QuadlingConnect With a Mentor Senior Software DeveloperCommented:
Does the URL work for you in a normal browser? I've just loaded the page in Chrome with no issue.

"Consuming Web Services in Excel 2007

Summary: Learn how to call the Live Search Web service from an Excel 2007 document-level customization and insert search results into a worksheet."

But there was a notice ...

"We were unable to locate this content in es-es.

Here is the same content in en-us."

http://msdn.microsoft.com/es-es/library/dd819156(en-us,office.12).aspx is the resultant URL.

Seems like the control you are using to display the content does not read the HTTP header properly.

Here is the response header I get for the URL you supplied ...

Request URL:http://msdn.microsoft.com/es-es/library/dd819156(v=office.12).aspx
Request Method:GET
Status Code:301 Moved Permanently

Request Headers
Accept:application/xml,application/xhtml+xml,text/html;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
User-Agent:Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US) AppleWebKit/534.3 (KHTML, like Gecko) Chrome/6.0.472.36 Safari/534.3

Response Headers
Connection:Keep-Alive
Content-Length:0
Date:Wed, 18 Aug 2010 11:19:24 GMT
Location:http://msdn.microsoft.com/es-es/library/dd819156(en-us,office.12).aspx
P3P:CP="ALL IND DSP COR ADM CONo CUR CUSo IVAo IVDo PSA PSD TAI TELo OUR SAMo CNT COM INT NAV ONL PHY PRE PUR UNI"
Proxy-Connection:Keep-Alive
Server:Microsoft-IIS/7.5
Via:1.1 BV-VM-SVR-17
X-Powered-By:ASP.NET

The "Location" header is an instant redirect of the es-es page to the en-us content.
0
 
enrique_aeoAuthor Commented:
ok my friend, i understand. Do you know other thr url? or something resources about "Consuming Web Services in Excel 2007"
0
 
Richard QuadlingSenior Software DeveloperCommented:
Sorry, no. I'm still using XP with Office 2003 - not sure if I'll make the jump to the "ribbon" interface. I've tried it in the office and just don't see the logic to it. I suppose after 20 years of the menu, I'm sort of used to it.

But I know a lot (I'm a genius, it says so on my profile !!! ;-) ), so maybe if you have some specific issues, I can help you find the answer.

Just doing a google search (http://www.google.co.uk/search?rlz=1C1GGLS_en-GBGB319GB319&aq=f&sourceid=chrome&ie=UTF-8&q=Consuming+Web+Services+in+Excel+2007) revealed a lot of information.

0
 
Richard QuadlingSenior Software DeveloperCommented:
Did you resolve the issue?
0
 
enrique_aeoAuthor Commented:
just try to replicate the example of Microsoft. What I do is create my own web service and try to invoke from the excel. I will try this weekend, if I have problems I will be writing again. Greetings and Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.