LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
External Data Query Marie Bayes Excel Discussion (Misc queries) 4 January 11th 07 06:08 PM
Get External Data-New Web Query saziz Excel Discussion (Misc queries) 1 May 23rd 06 10:22 PM
find and replace - replace data in rows to separated by commas msdker Excel Worksheet Functions 1 April 15th 06 01:00 AM
Import External Data/New WEB Query Carl Hopkins Excel Discussion (Misc queries) 0 February 10th 06 02:56 AM
Query of External Data Excel GuRu Excel Discussion (Misc queries) 2 January 3rd 05 07:43 PM


All times are GMT +1. The time now is 10:22 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"