LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default altering URLs with code


I need to modify complex URL's. An example of what I need to do is
modifying the following URL (incomplete, I know!):



Code:
--------------------
We_ViewEns.cfm?sItemCode=WedEns6146&sCatalogCode=W edEnsCC&iStartRow=1&strcontinue=yes&strsearch=yes& format=WedEnsCCa
--------------------



to replace the numbers in "WedEns6146" and "1&strcontinue" with
different numbers. ***I ultimately would be replacing these numbers on
thousands of similarly formatted URLs.

One way I thought of doing this was through the replace function, but
was not sure if there are syntax parameters to do so.

I thought also that may be I could do this with VB code (which I think
would be my preference)??

Can someone help me with this?

Thank You!


--
imimin
------------------------------------------------------------------------
imimin's Profile: http://www.excelforum.com/member.php...o&userid=37684
View this thread: http://www.excelforum.com/showthread...hreadid=574320

 
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
Edit All Hyperlink URLs Rebecca Excel Discussion (Misc queries) 2 December 17th 08 03:28 PM
Pasting a set of URLs? Terry Pinnell Excel Discussion (Misc queries) 5 May 12th 07 05:34 PM
Convert urls to links ellen Excel Discussion (Misc queries) 2 October 5th 06 12:25 PM
Altering code to accomodate empty space JOUIOUI Excel Programming 2 June 28th 06 05:17 PM
Altering code to reference the worksheet before the active worksheet KimberlyC Excel Programming 8 March 15th 05 10:26 PM


All times are GMT +1. The time now is 06:33 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"