Hi, on an internal web which only runs in IE or GC there is a button with id="ext-eng-123" where 123 is a set of 3 numbers that change everytime the page is clicked. It appears it is a set of up to maybe 20 different combination, so not many. The whole line reads: Inspect with Inspect . The div has title= "Initiate", class="text-truncate mb-2", id="gsw-sideber-startmenuitem", data-type="record", data-appid="82" and data-url="index.cfm?abc=&def=", I tried to call all possible elements, either it runs but doesnt click, or I get the 438 error. I would love to run it from excel. Many thanks Bez.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

VBA to click button on web with everchanging ID using IE

Thread starter bezuchoff
Start date May 31, 2018
Tags

button code click button with vba getelement set vba & web

bezuchoff

New Member

May 31, 2018

Hi,
on an internal web which only runs in IE or GC there is a button with id="ext-eng-123" where 123 is a set of 3 numbers that change everytime the page is clicked. It appears it is a set of up to maybe 20 different combination, so not many. The whole line reads: <td align="left" id="ext-eng-123" valign="middle">Inspect</td> with <div tittle:"Launch Insp" style="cursor: pointer;" *******="launchForm('882',82,'1092','index.cfm?Org=2&Loc=xyz','');"
Alternatively the button can be clicked at Start Menu where it reads: <span class="clickable" id="ext-eng-456">Inspect</span>. The div has title= "Initiate", class="text-truncate mb-2", id="gsw-sideber-startmenuitem", data-type="record", data-appid="82" and data-url="index.cfm?abc=&def=",
I tried to call all possible elements, either it runs but doesnt click, or I get the 438 error.
I would love to run it from excel.
Many thanks
Bez.