Help with a Macro - Excel 2003

B

Bob Smith

Hi folks,
I don't know much about coding macros and was hoping someone might provide
some advice. I have a workbook, with 50 or so worksheets querying 50
different URLs from one company. The company has changed their URLs from
http://www.ntn.com/hospitality_tech/players_corner/site.asp?id= to
http://players.buzztime.com/bt_site.php?s= .(Following each = is a different
number, like 1234 or 15923 ect.)

Is there a way to change those URLs on a global basis, and maintain the same
number following the = sign?

Thanks for any help you may be able to provide.

Regards, Bob
 
S

stacrafty

An easy way would be to highlight all your data and hit ctrl H to bring
up find and replace, place the first bit
(http://www.ntn.com/hospitality_tech/players_corner/site.asp?id=) in
find and then put http://players.buzztime.com/bt_site.php?s=, in
replace. This should update it.
Alternatively you could use a SS formula to find the "=" and replace
everything to the left of that with your new text
(http://players.buzztime.com/bt_site.php?s=)

Both would require a little bit of manual work still, are you looking
for an entirely automated solution?
 
B

Bob Smith

An easy way would be to highlight all your data and hit ctrl H to bring
up find and replace, place the first bit
(http://www.ntn.com/hospitality_tech/players_corner/site.asp?id=) in
find and then put http://players.buzztime.com/bt_site.php?s=, in
replace. This should update it.
Alternatively you could use a SS formula to find the "=" and replace
everything to the left of that with your new text
(http://players.buzztime.com/bt_site.php?s=)

Both would require a little bit of manual work still, are you looking
for an entirely automated solution?
Click to expand...

I tried your first solution, and it finds no text to replace. These are
queries which are buried in cell A1 in each sheet. As for your SS formula
solution, I'm sorry but I don't know what you are talking about.

And yes, I'm looking for an automated solution :).

Regards,

Bob
 
Top