HYPERLINK IMAGE MICRO

Hello friends, aaj ki post me hum aapko image se hyperlink ko extract kaise karte hai? ye batayenge. Hypelink kya hote hai aur inn links ko manual tarike se aur hyperlink text command se kaise extract karte hai yeh jaanne ke liye aap Hyperlink Text Micro me click karke dekh sakte hai.

Dosto aapne website me kai images dekhi hongi aur jab unn images par click kiya hoga to ek naye website open ho gayi hogi kyoki inn images me web address attahced hota hai inhi web address ko images se kaise extract karte hai excel worksheet me aaiye dekhe.

Step 1

Sabse pehle inn images ko website se excel worksheet me paste kare.

Step 2

Ab Alt+F8 press kare aur:-

1. Micro name me koi bhi name de sakte hai.
2. Create ke button par click kare.

Step 3

1. Iske baad jo micro box open hoga usme yeh command paste kar dijiye.

Sub GetHyperlinks()

  Dim NextRow As Long
  Dim Shp As Object

    NextRow = 1

    For Each Shp In ActiveSheet.Shapes
      If Shp.Type = msoPicture Then
        Cells(NextRow, “E”) = Shp.Hyperlink.Address
        NextRow = NextRow + 1
      End If
    Next Shp

End Sub

2. Play ki button par click kare.

Step 3

Ab aap Alt+Tab karke excel worksheet me dekh sakte hai ki images ke under se links extract ho gaye hai.

Dosto hyperlink images ki jaankari aapko kaisi lagi comment karke jaroor feedback de, aur agar yeh post pasand aayi ho to isse share karna na bhoole.

Ramesh Singh

Hello Dosto ! Mera Naam Ramesh Singh Hai. Main Ek Passionate Blogger Hun. Ye Website Maine Banai Hai. Is Website Par Main Longo Ko Hindi Me Jankari Deta Hun Aur Unki Help Karta Hun. Read More

Leave a Reply

Your email address will not be published. Required fields are marked *