View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
imimin[_3_] imimin[_3_] is offline
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