invoke web service from Excel 2003
 

I'm trying to invoke web service from Excel 2003, and I could never get it
working so far. I'm using Tools-Web Service References, but its never
working. I also understand we can use Visual Studio 2005 to create a excel
programming which i'm not very familiar with. I would like to use the first
option to invoke web service from Excel. any help would be appreciated. Thanks