Excel 2007 : Getting data from web services

Hi folks,

I've got a worksheet that calls a web service to get back some XML. It works great but each week I have to change the query string for the service being called to look at the new weeks data.

For example:

I'm currently using: /mydomain.com/mywebservice.asmx/weeklydata?week=1
next week I'll need data for: /mydomain.com/mywebservice.asmx/weeklydata?week=2

Ideally, I'd like the week parameter to be added to the query string, based on the value of a cell. e.g. if A1 = 3, it'll pass week 3 to the web service in the query string.

Anyone know how this can be achieved?

Sadly it just tries to call the webservice with " & Sheets(1).range("A1").value as the query string.

I suspect this isn't possible... the place you enter the URL is a standard windows dialog box so I'm not sure you can get it to look back at the sheet before it pings the service.

Still, if anyone knows a way...