excel - Excel IE 自动化，试图将我正在寻找的值变成一个变体

Question

我需要有关此问题的帮助.. 下面的代码正在运行，结果与我预期的一样，但我想为其他表运行此代码，并且每个表的条件中的日期和时间都会发生变化，但是格式始终是同样，我尝试使用类似的东西If td.innerText = "*" & "/" & "*" Then（在我的理解中应该寻找一个等于“某物/某物”的值），甚至设置这样的格式Set y = "??/??/???? ??:??:??"并尝试找到一个匹配项，y但它看起来像我'我在这里做错了什么。

'lots of code to get to the table and then... 

Dim tbl, td, tds

    Set tbl = IE.document.getElementById("table-pre")
    Set tds = tbl.getElementsByTagName("td")
    For Each td In tds
        If td.innerText = "01/01/2020 05:26:23" Then
            MsgBox td.NextSibling.NextSibling.innerText
            Exit For
    End If
    Next

网站代码

<div id="table-pre">
<div class="pre_name1">Inverter:</div>
<div class="pre_value1" id="inverterSNSelector"><select name="inverterOption" id="inverterOption" style="margin-left: -150px;" onchange="selectInvertor()"><option value="'ST20K17001063'">ST20K17001063</option><option value="'ST20K17001066'">ST20K17001066</option></select></div>
<div style="clear: left;"></div>
<table class="pretable"><tbody>
<tr>
<th class="prethtd">Inverter</th>
<th class="prethtd">Vpv1</th>
<th class="prethtd">Vpv2</th>
<th class="prethtd">Vpv3</th>
<th class="prethtd">Ipv1</th>
<th class="prethtd">Ipv2</th>
<th class="prethtd">Ipv3</th>
<th class="prethtd">Vac1</th>
<th class="prethtd">Vac2</th>
<th class="prethtd">Vac3</th>
<th class="prethtd">Iac1</th>
<th class="prethtd">Iac2</th>
<th class="prethtd">Iac3</th>
<th class="prethtd">Pac1</th>
<th class="prethtd">Pac2</th>
<th class="prethtd">Pac3</th>
<th class="prethtd">Fac</th>
<th class="prethtd">Temperatura (ºC)</th>
<th class="prethtd">Hora(GMT -3)</th>
<th class="prethtd">Energia hoje(kWh)</th>
<th class="prethtd">Energia Total(kWh)</th>
</tr>
<tr class="chart_list_even"><td class="prethtd">ST20K17001063</td>
<td class="prethtd">460.3</td>
<td class="prethtd">460.9</td>
<td class="prethtd">0.0</td>
<td class="prethtd">0.0</td>
<td class="prethtd">0.0</td>
<td class="prethtd">0.0</td>
<td class="prethtd">225.2</td>
<td class="prethtd">221.4</td>
<td class="prethtd">223.5</td>
<td class="prethtd">0.0</td>
<td class="prethtd">0.0</td>
<td class="prethtd">0.0</td>
<td class="prethtd">0</td>
<td class="prethtd">0</td>
<td class="prethtd">0</td>
<td class="prethtd">59.88</td>
<td class="prethtd">34.0</td>
<td class="prethtd">01/01/2020 05:26:23</td>
<td class="prethtd">0.0</td>
<td class="prethtd">58890.8</td>
</tr>

标签： excelvba