Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Edit All Hyperlink URLs | Excel Discussion (Misc queries) | |||
Pasting a set of URLs? | Excel Discussion (Misc queries) | |||
Convert urls to links | Excel Discussion (Misc queries) | |||
Altering code to accomodate empty space | Excel Programming | |||
Altering code to reference the worksheet before the active worksheet | Excel Programming |