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

altering URLs with code
 

If you will be using complex matching pattern, now may a good time to start
in on regular Expressions.

NickHK

"imimin" wrote in
message ...

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&strcon
tinue=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