Is posible to manipulate .href value Internet Explorer from VBA Excel

R

Rafael_Navarro

Joined
May 2, 2017
Messages
1
Reaction score
0
Hello people, I am new using or manipulated Internet Explorer
information from Excel VBA

At the company where I work, we are using Symantec Altiris to manage the existing hardware. At this moment I am in the stage of massive loading of information. As mentioned before I am using Excel and VBA to accelerate the process. I find myself in a problem that I describe below



"<A id=Assoc_74c9ad4_ARAEC_LabelAssocList onclick="return document.getElementById('Assoc_74c9ad4_ARAEC_ImgBtnMod').click()" href="#">Haga clic para seleccionar...</A>"

And i want this value

"<A id=Assoc_74c9ad4_ARAEC_LabelAssocList onclick="return document.getElementById('Assoc_74c9ad4_ARAEC_ImgBtnMod').click()" href="/Altiris/AssetContractCommon/Manager/EditCreateResource.aspx?itemGuid=289a262b-61c7-4d3f-9483-b5fd1c3778bb&amp;resourceGuid=289a262b-61c7-4d3f-9483-b5fd1c3778bb">Estación de trabajo</A>"

I am trying this

Set AllHyperlinks = IE.Document.getElementById("Assoc_74c9ad4_ARAEC_LabelAssocList")

AllHyperlinks.SetAttribute "href", "/Altiris/AssetContractCommon/Manager/EditCreateResource.aspx?itemGuid=289a262b-61c7-4d3f-9483-b5fd1c3778bb&resourceGuid=289a262b-61c7-4d3f-9483-b5fd1c3778bb"

Do Until Not IE.Busy And IE.ReadyState = 4

DoEvents

Loop
AllHyperlinks.innertext = “Estacion de Trabajo”


Any help? Sorry for my mistake but English is not my first language
 
Back
Top