Find/Replace External Data Web Query

[Gary Spranger]

I have a spreadsheet that refers to a bundle of web tables from a website. I
want to be able to mass replace the links on my spreadsheet so that a portion
of the web address being references gets changed

eg. Current address
http://xxx.yyy.com/Leaderboard_Stat...9&navid=10&StateID=2&SeasonQuarterID=4&Page=1

I want to change all references to &SeasonQuarterID=4 to &SeasonQuarterID=5

Doing this one sheet at a time is extremely time consuming. A solution would
be fantastic!

Thanks

 

[Don Guillett]

Designate a cell somewhere on a master sheet and just refer to it.

"http://xxx.yyy.com/Leaderboard_StateAvgQuarterly.asp?cid=89&navid=10&StateID=2&SeasonQuarterID="&range("a1")&"&Page=1"

Maybe you could use the same idea to cut down on the number of queries.

 

[Gary Spranger]

So you are saying in the Edit Web Query dialog box, In the address bar I can
refer to a cell on a master sheet rather than typing the actual web address
out?

 

[Don Guillett]

No, put the info in a cell and use a macro to do your web fetch.
When you have the external query, record a macro of you bringing up the url
and manually changing it to see how it can work. Post back if you still
can't get it or send me the actual url.