View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Smith
 
Posts: n/a
Default Help with a Macro - Excel 2003

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/...r/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