How to modify the value or link of a .href attribute from vba excel?

1

In my company we started using Altiris from Symantec At this moment I am in charge of the massive load of hardware inventories. I upload the information using Excel - VBA. The data loading formulations are in HTML and JavaScripts format

In a part of that form there is a link

  

Click to select ...

Code

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

and I need the .href attribute to have the following value

  

Workstation

Code

<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"
 target=_WinViewAssocRes>Estación de trabajo</A>

I used the following code in Excel VBA, although it works but when I save it does not take the changes

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 = "Estación de trabajo"

Any ideas on how to solve this error?

    
asked by Rafael Navarro 03.05.2017 в 18:48
source

0 answers