Find/Replace External Data Web Query
 

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_State...terID=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

Find/Replace External Data Web Query
 

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.

--
Don Guillett Excel MVP
SalesAid Software

"Gary Spranger" <Gary wrote in message
...
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_State...terID=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

Find/Replace External Data Web Query
 

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" wrote:

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.

--
Don Guillett Excel MVP
SalesAid Software

"Gary Spranger" <Gary wrote in message
...
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_State...terID=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

Find/Replace External Data Web Query
 

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.

--
Don Guillett Excel MVP
SalesAid Software

"Gary Spranger" wrote in message
...
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" wrote:

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.

--
Don Guillett Excel MVP
SalesAid Software

"Gary Spranger" <Gary wrote in
message
...
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_State...terID=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