Sub getredirectedurls() Dim i, j As Long Cells(2, 1).End(xlDown).Select 'to get last row j = ActiveCell.Row For i = 2 To j Dim myIE As Object Set myIE = CreateObject("InternetExplorer.Application") myIE.Navigate Cells(i, 1).Text Do While myIE.Busy Loop Cells(i, 2).Value = myIE.Document.URL myIE.Quit Set myIE = Nothing Next i 'sample url http://link.songs.pk/song1.php?songid=8000 End Sub
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)