Home » Forums » Open Source Learning Center » Question and Answer

VBA IE Tags issue

Submitted by deva_raju on 22 January, 2014 - 11:55

Dear Experts,

I have login to the IE browser and working all the functions. webpage changed After login to the website[displayed main page].I'm not able to get the tags or html elements from loaded page through VBA code. Here I'm getting initial page settings only.

Pl. can you help me to get the tags from loaded IE webpage...

VBA Code::

Set ElementCol = ie.Document.getElementsByTagName("a")

For Each link In ElementCol
If link.innerHTML = "Logout" Then
link.Click
Exit For
End If
Next link

‹ Need help with a formula or code that will copy data from a group of cells and paste it into another group of cells... Macro to merge data from multiple Worksheets in multiple Workbooks in a single master file ›
»

Set links =

Submitted by noel_vales on 3 February, 2014 - 19:10.

Set links = IE.document.getElementsByTagName("td")
For Each lnk In links
If lnk.className = "" Then
no = lnk.innerText'''saving it to a variable
ActiveSheet.Range("f1") = Right(no, 12)''''pasting to sheet in excel
Exit For
End If
Next

»