html - 如何从 IE 中未完全预加载 VBA 的下拉列表中选择选项?
问题描述
我正在尝试创建一个VBA macro
自动从网站的下拉列表中选择项目的项目。即使下拉列表中的选项有 id 标签,但不是整个列表都是preloaded
,因此当我硬编码选择选项的 ID 时会抛出错误。
[![在此处输入图像描述][1]][1]
第一张图片:这是第一次单击下拉列表时的情况(未显示所有选项)
[![在此处输入图像描述][2]][2]
第二张图片:一旦我将下拉列表滚动到底部,就会显示更多选项及其标签 ID!
即使我知道下拉菜单中最后一个选项的标签 ID,我也无法硬编码选择它,因为它does not exist
在网页上,直到下拉菜单向下滚动并显示选项。
我怎样才能通过 VBA 来显示所有选项?
提前致谢!:)
<!DOCTYPE html>
<html>
(head removed)
<body class="mainframe new-component-style" id="mainBody">
<form name="form1" class="ng-pristine ng-valid" id="form1" onsubmit="doSubmit();return true;" action="/pagesUTF8/auftrag_allgemeinauftrag.jsp" method="post" accept-charset="utf-8">
<div class="bgcContent" id="bg_site">
<div id="bg_site_inner">
<div class="ContentBox ContentBox2Spalten">
<div class="ContentBoxContainer">
<div>
<table width="100%" id="AjaxCon35" aria-live="polite" style="border: 0px currentColor; border-image: none;" cellspacing="0" cellpadding="2">
<tbody>
<tr>
<td style="padding: 0px;" colspan="4">
<div style="padding: 4px 0px; width: 100%; -ms-overflow-y: auto; max-height: 570px;">
<table style="width: 100%;">
<tbody>
<tr class="OutTabBodyBack_white" id="AjaxCon32" aria-live="polite">
<td class="OutTabBody_NoBorder">
<div class="component-group" style="width: 100%;">
<div class="tagbox-wrapper ng-non-bindable">
<div class="tagBox single-select" id="ATagBox10ASSPLJ" style="top: 431.69px; width: 258.02px; position: fixed; z-index: 9999;" name="ATagBox05ASSPLJ">
<div class="tagBoxWrapper focus" id="ATagBox05ASSPLJ" name="ATagBox05ASSPLJ">
<div class="selectWrapper" style="display: none;">
<div>
<select name="ASSPLJ" class="form-element ng-non-bindable" id="ASSPLJ">
<option id="ATagBox07#ASSPLJ#1187" selected="selected" value="1187"></option>
</select>
</div>
</div>
<script type="text/javascript">
/* <![CDATA[ */
addToGwtFunctionQueue('initTagBox', ['ASSPLJ', {
"noEntryFoundTxt": "No entries found",
"stdTxt": "Please select",
"isMultiSelect": false,
"autoReturn": "DoAjaxProjekt(\"AjaxCon32\", \"ASSPLJ\", \"3\", \"2001906\");",
"isOpenToTop": false
}]);
/* ]]> */
</script>
<div class="outerWrapper" style="width: 100%;">
<div class="dropDownButtonContainer"><button class="dropDownButton" id="TagBoxDropDownASSPLJ" type="button"><span class="icon-arrow-down"></span></button></div>
<div class="fakeSelect" id="ATagBox03ATagBox08ASSPLJ" style="width: 225px;">
<div class="fakeSelectInnerWrapper active">
<div title="Yin" class="tag-value ellipsis" id="ATagBox06#ASSPLJ#1187"><span>Yin</span></div>
<div class="textBoxSearchWrapper"><input class="textBoxSearchWrapper" id="ATagBox01ASSPLJ" type="text" autocomplete="off"></div>
</div>
</div>
</div>
</div>
<div class="fakeDropDown" style="height: 400px; overflow: auto; display: block; position: absolute; -ms-overflow-y: scroll; -ms-zoom: 1;">
<div style="position: relative; -ms-zoom: 1;">
<div>
<div class="tag" id="ATagBox02#ASSPLJ#1">
<div class="ellipsis" style="padding-right: 2px; float: left;">John 1</div>
</div>
<div class="tag" id="ATagBox02#ASSPLJ#261">
<div class="ellipsis" style="padding-right: 2px; float: left;">John 2</div>
</div>
<div class="tag" id="ATagBox02#ASSPLJ#385">
<div class="ellipsis" style="padding-right: 2px; float: left;">John 3</div>
</div>
<div class="tag" id="ATagBox02#ASSPLJ#1045">
<div class="ellipsis" style="padding-right: 2px; float: left;">John 4</div>
</div>
<div class="tag" id="ATagBox02#ASSPLJ#1032">
<div class="ellipsis" style="padding-right: 2px; float: left;">John 5</div>
</div>
<div class="tag" id="ATagBox02#ASSPLJ#257">
<div class="ellipsis" style="padding-right: 2px; float: left;">John 6a</div>
</div>
<div class="tag" id="ATagBox02#ASSPLJ#708">
<div class="ellipsis" style="padding-right: 2px; float: left;">John 7</div>
</div>
<div class="tag" id="ATagBox02#ASSPLJ#1123">
<div class="ellipsis" style="padding-right: 2px; float: left;">John 8</div>
</div>
<div class="tag" id="ATagBox02#ASSPLJ#4">
<div class="ellipsis" style="padding-right: 2px; float: left;">John 9</div>
</div>
<div class="tag" id="ATagBox02#ASSPLJ#6">
<div class="ellipsis" style="padding-right: 2px; float: left;">John 10</div>
</div>
<div class="tag" id="ATagBox02#ASSPLJ#10">
<div class="ellipsis" style="padding-right: 2px; float: left;">John 11</div>
</div>
<div class="tag" id="ATagBox02#ASSPLJ#1034">
<div class="ellipsis" style="padding-right: 2px; float: left;">John 12</div>
</div>
<div class="tag" id="ATagBox02#ASSPLJ#269">
<div class="ellipsis" style="padding-right: 2px; float: left;">John 13</div>
</div>
<div class="tag" id="ATagBox02#ASSPLJ#9">
<div class="ellipsis" style="padding-right: 2px; float: left;">John 14</div>
</div>
<div class="tag" id="ATagBox02#ASSPLJ#1049">
<div class="ellipsis" style="padding-right: 2px; float: left;">John 15</div>
</div>
<div class="tag" id="ATagBox02#ASSPLJ#454">
<div class="ellipsis" style="padding-right: 2px; float: left;">John 16</div>
</div>
<div class="tag" id="ATagBox02#ASSPLJ#706">
<div class="ellipsis" style="padding-right: 2px; float: left;">John 17</div>
</div>
<div class="tag" id="ATagBox02#ASSPLJ#1175">
<div class="ellipsis" style="padding-right: 2px; float: left;">John 18</div>
</div>
<div class="tag" id="ATagBox02#ASSPLJ#1037">
<div class="ellipsis" style="padding-right: 2px; float: left;">John 19</div>
</div>
<div class="tag" id="ATagBox02#ASSPLJ#709">
<div class="ellipsis" style="padding-right: 2px; float: left;">John 20</div>
</div>
</div>
</div>
</div>
</div>
</div>
<div tabindex="0" class="dropdown">
<ul class="dropdown-menu" role="menu">
<li role="presentation"><a role="menuitem" onclick="SelectTabelle('OSG021187');"><span>Go to details</span></a></li>
<li role="presentation"><a role="menuitem" onclick="SelectTabelle('OSG352-1187');"><span>Send e-mail</span></a></li>
</ul>
<div class="btn-group new-componenent-style"><a class="btn btncol-secondary dropdown-toggle" aria-label="Options" data-tooltip="Options"><span class="icon-more"></span></a></div>
</div>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</td>
</tr>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</form>
</body>
</html>
解决方案
推荐阅读
- excel - Excel 组合框下拉循环
- r - 用列表替换 r data.table 中的 NULL 和 NA
- amazon-web-services - AWS Lambda V4 签名。我们计算的请求签名与您提供的签名不匹配。检查您的 AWS 秘密访问密钥
- flutter - LateInitializationError:字段尚未初始化。在 FutureBuilder 中运行 firebase 查询后,.then() 命令未运行
- sorting - Power BI 按列(日期)排序在两个图表上产生不同的结果
- blockchain - 在 swapExactTokensForTokens (UniswapV2Router02, web3.js) 期间恢复交易
- r - 如何去除异常值和因子变量?
- wordpress - Wordpress:当我点击搜索结果时,它给出了 404
- python - 标签不会持续更新 Tkinter
- javascript - 如何基于 sessionStorage 显示菜单项