Hi folks,

I have a workbook, with about 30 or so web queries from a trivia stats
website. I'd like to share this workbook with a few friends, to where they
can modify the URL for their player number to pull down their stats.

Is there any easy way to set up a macro or VB script to modify the urls in
each of these queries, to replace my player number to their player number?
At one time?

Now, I know that the other people will have to do an edit query on each
query to select the specific table, but at least they won't have to modify
each URL as well.

If a VB script is suggested, I need some additional help on where to insert
that code within my workbook.

TIA.

Bob