Select part of hyperlink address via VBA

[Ron]

Using VBA a For/Next routine I'm trying to open IE pages from a range
of cells.

From the link address
(http://www.azxxxaz.com/fooo/detail.php?save=1&id=123456) how can I
select just the six numbers following the "=" sign to be the
identifier in each loop.

Below is the path I'm on but how do I handle the identifier.

'MyExLink = "http://www.azxxxaz.com/fooo/detail.php?save=1&id="
'
'ActiveWorkbook.FollowHyperlink Address:="MyExLink" + "123456", _
' NewWindow:=True



TIA

Ron

 

[mrice]

You can use Right


Right("http://www.azxxxaz.com/fooo/detail.php?save=1&id=123456",6)
12345

 

[Ron]

You can use Right


Right("http://www.azxxxaz.com/fooo/detail.php?save=1&id=123456",6) =
123456

Wow!!

Are you fast out of the blocks.... 22 minutes.

Thank you I will test it tomorrow.

Ron