我有一個加載網頁的宏,我必須在一個欄位中輸入一系列日期的起始日期和結束日期。在欄位的右邊有一個按鈕,顯示一個日歷(網格),你可以點擊它來選擇起始日期和結束日期。
如果我通過VBA輸入,它會顯示一個訊息框 "你必須輸入選擇的日期來顯示表格"。 如果我用按鈕輸入,它就能正常作業。 這是我的代碼:
Sub Sail3()
Dim即As Object
Dim frm As Variant
Dim element As Variant
Dim datesailAs String
Set ie = New InternetExplorerMedium
ie.navigate "http://pfrwtekref/websail/"/span>
While ie.readyState <> 4: DoEvents: 補上
Set frm = ie.document.getElementById("Form1"/span>)
ie.Visible = True[/span]。
ie.document.getElementById("Form1").elements("txtLogin").Value = ----private。
ie.document.getElementById("Form1").elements("txtPwd").Value = -----------private>
ie.document.getElementById("Form1").elements("Button1") .Click
ie.navigate "http://pfrwtekref/websail/frmSuiviActivite2.aspx"。
While ie.readyState <> 4: DoEvents: 終止
ie.document.getElementById("Form1").elements("DateDebut").Value = Date。
i.document.getElementById("Form1").elements("DateFin").Value=Date。
i.document.getElementById("Form1").elements("btn_Resultat") .Click
End Sub
。
。
< ! DOCTYPE HTML PUBLIC "-/W3C/DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD><title>
活動追蹤
</title> meta content="Microsoft Visual Studio .NET 7. 1" name="GENERATOR">< meta content="Visual Basic . NET 7. 1" name="CODE_LANGUAGE">/span>< meta content="JavaScript" name="vs_defaultClientScript" > <meta content="http: //schemas. microsoft. com/intellisense/ie5" name="vs_targetSchema"/span>> <link href="style. css" type="text/css" rel="styleheet" /> </HEAD>>
<body MS_POSITIONING="GridLayout">
< form name="Form1" method="post" action="。 /frmSuiviActivite2.aspx" id="Form1">
< input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE" value="/wEPDwUJNTMxMzIxNTY2D2QWAgIDD2QWAgISDzwrAAsAZGScOQoNqGNqyktNdNb5duOihHfSXDhXwJMIdrEy WJPjQ=="/>。
< input type="hidden"/span> name="__VIEWSTATEGENERATOR" id="__VIEWSTATEGENERATOR" value="BC9C9B4F" />
< input type="hidden" name="__EVENTVALIDATION"/span> id="__EVENTVALIDATION"/span> value="/wEdAAfLmZQgUyFrp RtWRcn8WdyGhTo VLfEoiQDWerbcGjiKDfFJNoZm2vzKsM7PzPDpwulGLYm9lXIP2asThkLC1apobPVZ60uUnrD2vRXyjteTbfGbMKwn GJo6LfUjoxo88T xOKs2R9iIIXy/DTbdWjeFlT81n dvcqoy Mi28ir9R143smwIFKGM/CIVtiqM="/span> />。
<span id="Label1"/span> style="font-weight: bold;Z-INDEX: 100; LEFT: 128px; POSITION: absolute; TOP: 144px">Date de début :</span>
< input type="submit" name="btn_Quitter" value="Quitter" id="btn_Quitter" class="MyBoutonQuitter" style="width: 121px;Z-INDEX: 112; LEFT: 720px; POSITION: absolute; TOP: 72px" />< span id="Label3"/span> class="MyTitre" style="width: 224px;Z-INDEX: 105; LEFT: 330px; POSITION: absolute; TOP: 60px">Suivi d'activité</span>
<span id="Label2"/span> style="font-weight: bold;Z-INDEX: 101; LEFT: 400px; POSITION: absolute; TOP: 144px">Date de fin :</span>
< input name="DateDebut" type="text" readonly="readonly" id="DateDebut" style="Z-INDEX。102; LEFT: 128px; POSITION: absolute; TOP: 168px" />
< input name="DateFin" type="text" readonly="readonly" id="DateFin" style="Z-INDEX。103; LEFT: 400px; POSITION: absolute; TOP: 168px" />
< input type="submit" name="btn_ChoixDebut" value="Choix" id="btn_ChoixDebut" class="MyBoutonChoix" style="width: 80px;Z-INDEX: 106; LEFT: 288px; POSITION: absolute; TOP: 168px"/span> />
< input type="submit" name="btnChoixFin" value="Choix" id="btnChoixFin" class="MyBoutonChoix" style="width: 80px;Z-INDEX: 104; LEFT: 560px; POSITION: absolute; TOP: 168px"/span> />
< input type="submit" name="btn_Resultat" value="Resultat" id="btn_Resultat" class="MyBoutonResultat" style="Z-INDEX: 109; LEFT: 665px; POSITION: absolute; TOP: 168px" /></form>
</body>
</HTML>/span>
<iframe name="sif1" sandbox="allow-forms allow-modals allow-scripts" class="snippet-box-edit snippet-box-result" frameborder="0"></iframe>
按下 "Choix "后的代碼:
< ! DOCTYPE HTML PUBLIC "-/W3C/DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD><title>
活動追蹤
</title> meta content="Microsoft Visual Studio .NET 7. 1" name="GENERATOR">< meta content="Visual Basic . NET 7. 1" name="CODE_LANGUAGE">/span>< meta content="JavaScript" name="vs_defaultClientScript" > <meta content="http: //schemas. microsoft. com/intellisense/ie5" name="vs_targetSchema"/span>> <link href="style. css" type="text/css" rel="styleheet" /> </HEAD>>
<body MS_POSITIONING="GridLayout">
< form name="Form1" method="post" action="。 /frmSuiviActivite2.aspx" id="Form1">
< input type="hidden" name="__EVENTTARGET" id="__EVENTTARGET" value=" />
< input type="hidden" name="__EVENTARGUMENT" id="__EVENTARGUMENT" value=" />
< input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE" value="/wEPDwUJNTMxMzIxNTY2D2QWAgIDD2QWBAIHDzwrAAoBAA8WAh4HVmlzaWJsZWdkZAISDzwrAAsAZGQo b6VGPdlaLrfd 6qWWHge Ke74Fr3jjEbH6mfUec8w=="/>。
<script type="text/javascript">/span>
<!--
var theForm = document.forms['Form1'];
if (!theForm) {
theForm = document.Form1;
}
函式 __doPostBack(eventTarget, eventArgument) {
如果(!theForm.onsubmit || (theForm.onsubmit() != false)) {
theForm.__EVENTTARGET.value = eventTarget;
theForm.__EVENTARGUMENT.value = eventArgument;
theForm.submit()。
}
}
// -->
</script>>
< input type="hidden" name="__VIEWSTATEGENERATOR" id="__VIEWSTATEGENERATOR" value="BC9C9B4F" />
< input type="hidden" name="__EVENTVALIDATION"/span> id="__EVENTVALIDATION"/span> value="/wEdADOztrz0Gg6bn5 0Kl9l3uwKGhTo VLfEoiQDWerbcGjiFoZONyZ6BSK3tMN8GplmUQxiPjZiofWtUlJULh4AdTbfRWuWAxRXzxvcKc1Zc mOWOPZwnWqionmbDSbiZkc tUfXxU9/wS RPOpYtmV8nbw7Ukm0kQjVMZCc/YCgExUQjyuRl6qtGOIAF5EKoHRfSdEUb8hFuKHe kl46W8n/9iwdjB2dhwgnbAsk79BDu6dAmNwyizE5 CDxjaKolTpybHan5sGI8vcqFHRtyO9j3idO9k97GrbFLq0lqy7I5uwJUg3LxVBnp0jTXUc25DpQeuA0BIkQiaSJuPN/LGglVcwRUWnjLpjUWdiF1zNiE3O SdNDXv15A9LUvRj 6QYrkUpPqxC67c039 Yt45W2TxDM8a2vNFe tTh79R zb5vvPBcsBbCThBfE/C79ruLDg1DJ DUWy ZQLvnukpIOaysup67s2O21Yt2LIVvx IdDifzoT1d4fbeB2FFWPB6bnMbGw/fFhCdJfgs NlIi8DkBweRdZ5EDWNPGdenNqradH2x3djttuXeOQWc tLPqTExYWHQVlWrqaqPaFWtfsFfqHHwWvHWtPuA9 ZqyRf6S9zC5vtwh3zJCMu iJOopiRA3i0mbQsFn9282DbtCgVeSaFhfMGDeBRCiX1veTskxJug4XARY/xWT UYuu M0ul3Cpqboc3tndvQPF1sFh7Du9CPQxiANH/kg1nVCM9AkHKegiqd06oA8w0wl40V9HHMKejpwrqf0azqgpenAyS4Wg W7v9c zzudU8v8VIY3Y/ yR sbxvUi4YcUvFzCEj0ki5TGsMyr6Ny70jbnaueoOTXWN05ii YfOd7l5JoexTMqVgccCkpbAj3a2VZ31qbCIm6D3HkFCCC0W 015JiT75TYuRCmsL70MfigQZEEvJO8g6NZ0ZX3RU/vvtbmkDRPF7vgROkjGGwilflHioN8Uk2hmba/Mqwzs/M8OnC6UYti />。
<span id="Label1"/span> style="font-weight: bold;Z-INDEX: 100; LEFT: 128px; POSITION: absolute; TOP: 144px">Date de début :</span>
< input type="submit" name="btn_Quitter" value="Quitter" id="btn_Quitter" class="MyBoutonQuitter" style="width: 121px;Z-INDEX: 112; LEFT: 720px; POSITION: absolute; TOP: 72px" />< span id="Label3"/span> class="MyTitre" style="width: 224px;Z-INDEX: 105; LEFT: 330px; POSITION: absolute; TOP: 60px">Suivi d'activité</span>
< table id="Calendar1"/span> tabindex="2" cellspacing="0" cellpadding="0" cellpadding="0" string">"0" title="日歷" bordercolor="#999999" border="0"/span> style="width: 208px;height:136px;font-size:8pt;font-family:Times New Roman;color:Black;border-width:1px;border-style:solid;border-color:#999999;background-color:White;border-collapse:collapse;Z-INDEX: 110; LEFT: 128px; POSITION: absolute; TOP: 200px"/span>> /span>
<tr>< td colspan="7" style="背景色。 Gold;border-color: Black;">< table cellspacing="0"/span> border="0" style="color: Black;font-family:Times New Roman;font-size:8pt;font-weight:bold;width:100%;border-collapse:collapse;"/span>>/span>
<tr>< td valign="bottom"/span> style="width: 15%;"><a href="javascript。 __doPostBack('Calendar1','V7852')" style="color: Black" title="Go to the previous month"> <</a> < /td>< td align="center"/span> style="width: 70%;">ao?t 2021</td><。 td align="right" valign="bottom" style="width: 15%;"><a href="javascript。 __doPostBack('Calendar1','V7914')" style="color: Black" title="Go to the next month">><。 a></td></tr>>
</table></td> < /tr><tr> < th align="center"/span> abbr="lundi" scope="col" style="background-color。 #CCCCCC;font-size:7pt;font-weight: bold;">l</th>< th align="center"/span> abbr="mardi" scope="col" style="background-color。 #CCCCCC;font-size:7pt;font-weight: bold;">m</th>< th align="center"/span> abbr="mercredi" scope="col" style="background-color。 #CCCCCC;font-size:7pt;font-weight: bold;">m</th>< th align="center"/span> abbr="Jeudi" scope="col" style="background-color。 #CCCCCC;字體大小。 7pt;font-weight: bold;">j</th><。 th align="center"/span> abbr="vendredi" scope="col" style="background-color。 #CCCCCC;font-size:7pt;font-weight: bold;">v</th>< th align="center"/span> abbr="samedi" scope="col" style="background-color。 #CCCCCC;字體大小。 7pt;font-weight: bold;">s</th><。 th align="center"/span> abbr="dimanche" scope="col" style="background-color。 #CCCCCC;font-size:7pt;font-weight: bold;">d</th>< /tr><tr> <td align="center" style=color: Gray;width:14%;"><a href="javascript。 __doPostBack('Calendar1','7877')" style="color: 灰色" title="26 juillet"> 26< /a></td> <td align="center" style="color: Gray;width:14%;"><a href="javascript。 __doPostBack('Calendar1','7878')" style="color: 灰色" title="27 juillet"> 27< /a></td> <td align="center" style="color: Gray;width:14%;"><a href="javascript。 __doPostBack('Calendar1','7879')" style="color: 灰色" title="28 juillet"> 28< /a></td> <td align="center" style="color: Gray;width:14%;"><a href="javascript。 __doPostBack('Calendar1','7880')" style="color: 灰色" title="29 juillet">29< /a></td> <td align="center" style=color: 灰色;寬度。 14%;"><a href="JavaScript: __doPostBack('Calendar1','7881')" style="color: 灰色" title="30 juillet"> 30< /a></td> <td align="center"/span> style="color: Gray;background-color:#FFFFCC;width:14%;"><a href="javascript。 __doPostBack('Calendar1','7882')" style="color: 灰色" title="31 juillet">31< /a></td> <td align="center" style="background-color: #FFFFCC;width:14%;"><a href="JavaScript: __doPostBack('Calendar1','7883')" style="color: Black" title="1 ao?t">1</a> </td> </tr> <tr>< td align="center"/span> style="width: 14%;"><a href="javascript: __doPostBack('Calendar1','7884')" style="color: 黑" title="2 ao?t"> 2< /a></td> <td align="center"/span> style="width: 14%;"><a href="javascript: __doPostBack('Calendar1','7885')" style="color: 黑" title="3 ao?t"> 3< /a></td> <td align="center"/span> style="width: 14%;"><a href="javascript: __doPostBack('Calendar1','7886')" style="color: 黑" title="4 ao?t"> 4< /a></td> <td align="center"/span> style="width: 14%;"><a href="javascript: __doPostBack('Calendar1','7887')" style="color: Black" title="5 ao?t">5< /a></td> <td align="center"/span> style="width: 14%;"><a href="javascript: __doPostBack('Calendar1','7888')" style="color: Black" title="6 ao?t">6< /a></td> <td align="center" style="background-color: #FFFFCC;width:14%;"><a href="JavaScript: __doPostBack('Calendar1','7889')" style="color: 黑" title="7 ao?t">7<。 /a></td> <td align="center" style="background-color: #FFFFCC;width:14%;"><a href="JavaScript: __doPostBack('Calendar1','7890')" style="color: Black" title="8 ao?t">8< /a> </td> </tr> <tr>< td align="center" style=color: Black;background-color:#CCCCCC;width:14%;"><a href="javascript。 __doPostBack('Calendar1','7891')" style="color: 黑" title="9 ao?t">9< /a></td> <td align="center"/span> style="width: 14%;"><a href="javascript: __doPostBack('Calendar1','7892')" style="color: Black" title="10 ao?t">10< /a></td> <td align="center"/span> style="width: 14%;"><a href="javascript: __doPostBack('Calendar1','7893')" style="color: Black" title="11 ao?t">11< /a></td> <td align="center"/span> style="width: 14%;"><a href="javascript: __doPostBack('Calendar1','7894')" style="color: Black" title="12 ao?t">12< /a></td> <td align="center"/span> style="width: 14%;"><a href="javascript: __doPostBack('Calendar1','7895')" style="color: Black" title="13 ao?t">13< /a></td> <td align="center" style="background-color: #FFFFCC;width:14%;"><a href="JavaScript: __doPostBack('Calendar1','7896')" style="color: Black" title="14 ao?t">14< /a></td> <td align="center" style="background-color: #FFFFCC;width:14%;"><a href="JavaScript: __doPostBack('Calendar1','7897')" style="color: Black" title="15 ao?t">15< /a> </td> </tr> <tr>< td align="center"/span> style="width: 14%;"><a href="javascript: __doPostBack('Calendar1','7898')" style="color: Black" title="16 ao?t">16< /a></td> <td align="center"/span> style="width: 14%;"><a href="javascript:__doPostBack('Calendar1','7899') "
style="color: Black" title="17 ao?t">17< /a></td> <td align="center"/span> style="width: 14%;"><a href="javascript: __doPostBack('Calendar1','7900')" style="color: Black" title="18 ao?t">18< /a></td> <td align="center"/span> style="width: 14%;"><a href="javascript: __doPostBack('Calendar1','7901')" style="color: Black" title="19 ao?t">19< /a></td> <td align="center"/span> style="width: 14%;"><a href="javascript: __doPostBack('Calendar1','7902')" style="color: Black" title="20 ao?t">20< /a></td> <td align="center" style="background-color: #FFFFCC;width:14%;"><a href="JavaScript: __doPostBack('Calendar1','7903')" style="color: 黑" title="21 ao?t">21< /a></td> <td align="center" style="background-color: #FFFFCC;width:14%;"><a href="JavaScript: __doPostBack('Calendar1','7904')" style="color: Black" title="22 ao?t">22</a> </td> </tr> <tr>< td align="center"/span> style="width: 14%;"><a href="javascript: __doPostBack('Calendar1','7905')" style="color: 黑" title="23 ao?t">23< /a></td> <td align="center"/span> style="width: 14%;"><a href="javascript: __doPostBack('Calendar1','7906')" style="color: 黑" title="24 ao?t"> 24< /a></td> <td align="center"/span> style="width: 14%;"><a href="javascript: __doPostBack('Calendar1','7907')" style="color: 黑" title="25 ao?t">25<。 /a></td> <td align="center"/span> style="width: 14%;"><a href="javascript: __doPostBack('Calendar1','7908')" style="color: 黑" title="26 ao?t"> 26< /a></td> <td align="center"/span> style="width: 14%;"><a href="javascript: __doPostBack('Calendar1','7909')" style="color: 黑" title="27 ao?t"> 27< /a></td> <td align="center" style="background-color: #FFFFCC;width:14%;"><a href="JavaScript: __doPostBack('Calendar1','7910')" style="color: 黑" title="28 ao?t"> 28< /a></td> <td align="center" style="background-color: #FFFFCC;width:14%;"><a href="JavaScript: __doPostBack('Calendar1','7911')" style="color: 黑" title="29 ao?t">29< /a> </td> </tr> <tr>< td align="center"/span> style="width: 14%;"><a href="javascript: __doPostBack('Calendar1','7912')" style="color: Black" title="30 ao?t">30< /a></td> <td align="center"/span> style="width: 14%;"><a href="javascript:__doPostBack('Calendar1','7913') "
style="color: Black" title="31 ao?t">31< /a></td> <td align="center" style="color: Gray;width:14%;"><a href="javascript。 __doPostBack('Calendar1','7914')" style="color: 灰色" title="1 septembre"> 1< /a></td> <td align="center" style="color: Gray;width:14%;"><a href="javascript。 __doPostBack('Calendar1','7915')" style="color: 灰色" title="2 septembre"> 2< /a></td> <td align="center" style=color: 灰色;寬度。 14%;"><a href="JavaScript: __doPostBack('Calendar1','7916')" style="color: 灰色" title="3 septembre"> 3< /a></td> <td align="center"/span> style="color: Gray;background-color:#FFFFCC;width:14%;"><a href="javascript。 __doPostBack('Calendar1','7917')" style="color: 灰色" title="4 septembre"> 4< /a></td> <td align="center"/span> style="color: Gray;background-color:#FFFFCC;width: 14%;"><a href="JavaScript: __doPostBack('Calendar1','7918')" style="color: 灰色" title="5 septembre">5< /a> </td></tr>
</table>< span id="Label2"/span> style="font-weight: bold;Z-INDEX: 101; LEFT: 400px; POSITION: absolute; TOP: 144px">Date de fin :</span>
< input name="DateDebut" type="text" readonly="readonly" id="DateDebut" style="Z-INDEX。102; LEFT: 128px; POSITION: absolute; TOP: 168px" />
< input name="DateFin" type="text" readonly="readonly" id="DateFin" style="Z-INDEX。103; LEFT: 400px; POSITION: absolute; TOP: 168px" />
< input type="submit" name="btn_ChoixDebut" value="Choix" id="btn_ChoixDebut" class="MyBoutonChoix" style="width: 80px;Z-INDEX: 106; LEFT: 288px; POSITION: absolute; TOP: 168px"/span> />
< input type="submit" name="btnChoixFin" value="Choix" id="btnChoixFin" class="MyBoutonChoix" style="width: 80px;Z-INDEX: 104; LEFT: 560px; POSITION: absolute; TOP: 168px"/span> />
< input type="submit" name="btn_Resultat" value="Resultat" id="btn_Resultat" class="MyBoutonResultat" style="Z-INDEX: 109; LEFT: 665px; POSITION: absolute; TOP: 168px" /></form>
</body>
</HTML>/span>
<iframe name="sif2" sandbox="allow-forms allow-modals allow-scripts" class="snippet-box-edit snippet-box-result" frameborder="0"></iframe>
選擇日期后的代碼:
。< ! DOCTYPE HTML PUBLIC "-/W3C/DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD><title>
活動追蹤
</title> meta content="Microsoft Visual Studio .NET 7. 1" name="GENERATOR">< meta content="Visual Basic . NET 7. 1" name="CODE_LANGUAGE">/span>< meta content="JavaScript" name="vs_defaultClientScript" > <meta content="http: //schemas. microsoft. com/intellisense/ie5" name="vs_targetSchema"/span>> <link href="style. css" type="text/css" rel="styleheet" /> </HEAD>>
<body MS_POSITIONING="GridLayout">
< form name="Form1" method="post" action="。 /frmSuiviActivite2.aspx" id="Form1">
< input type="hidden" name="/wEPDwUJNTMxMzIxNTY2D2QWAgIDD2QWCgIGDzwrAAoBAA8WBB4HVmlzaWJsZWgeAlNEFgEGAEBQIm1Y2QhkZAIHDzwrAAoBAA8WBB8AaB8BFgEGAEBQIm1Y2QhkZAIKDw8WAh4EVGV4dAUKMDYvMDgvMjAyMWRkAgwPDxYCHwIFCjA2LzA4LzIwMjFkZAISDxQrAAsPFgoeCERhdGFLZXlzFgAeC18hSXRlbUNvdW50AgEeCVBhZ2VDb3VudAIBHhVfIURhdGFTb3VyY2VJdGVtQ291bnQCAR8AZ2RkZBYEHghDc3NDbGFzcwUQTXlEYXRhZ3JpZEhlYWRlch4EXyFTQgICZBYEHwcFDk15RGF0YWdyaWRJdGVtHwgCAmQWBB8HBRZNeURhdGFncmlkU2VsZWN0ZWRJdGVtHwgCAmQWBB8HBQpNeURhdGFncmlkHwgCAhQrAAY8KwAEAQAWCB4KSGVhZGVyVGV4dAUERGF0ZR4JRGF0YUZpZWxkBQREYXRlHg5Tb3J0RXhwcmVzc2lvbgUERGF0ZR4IUmVhZE9ubHloPCsABAEAFggfCQURQ2FydG9ucyBTVEQgLyBDQU8fCgURQ2FydG9ucyBTVEQgLyBDQU8fCwURQ2FydG9ucyBTVEQgLyBDQU8fDGg8KwAEAQAWCB8JBRJQYWxldHRlcyBTVEQgLyBDQU8fCgUSUGFsZXR0ZXMgU1REIC8gQ0FPHwsFElBhbGV0dGVzIFNURCAvIENBTx8MaDwrAAQBABYIHwkFEkTDqXZvecOpIFNURCAvIENBTx8KBRJEw6l2b3nDqSBTVEQgLyBDQU8fCwUSRMOpdm95w6kgU1REIC8gQ0FPHwxoPCsABAEAFggfCQURVG9ubmFnZSBTVEQgLyBDQU8fCgURVG9ubmFnZSBTVEQgLyBDQU8fCwURVG9ubmFnZSBTVEQgLyBDQU8fDGg8KwAEAQAWCB8JBRBMaWduZXMgU1REIC8gQ0FPHwoFEExpZ25lcyB />。
< input type="hidden" name="__VIEWSTATEGENERATOR" id="__VIEWSTATEGENERATOR" value="BC9C9B4F" />
< input type="hidden" name="__EVENTVALIDATION"/span> id="__EVENTVALIDATION"/span> value="/wEdAAe9tF3Oa7CP1zw1oQDDCiBAGhTo VLfEoiQDWerbcGjiKDfFJNoZm2vzKsM7PzPDpwulGLYm9lXIP2asThkLC1apobPVZ60uUnrD2vRXyjteTbfGbMKwn GJo6LfUjoxo88T xOKs2R9iIIXy/DTbdWg1gvqgNQzBkfcXFpD53EFX2sza3EXD3gHd2X ykW8="/span> />。
<span id="Label1"/span> style="font-weight: bold;Z-INDEX: 100; LEFT: 128px; POSITION: absolute; TOP: 144px">Date de début :</span>
< input type="submit" name="btn_Quitter" value="Quitter" id="btn_Quitter" class="MyBoutonQuitter" style="width: 121px;Z-INDEX: 112; LEFT: 720px; POSITION: absolute; TOP: 72px" />< span id="Label3"/span> class="MyTitre" style="width: 224px;Z-INDEX: 105; LEFT: 330px; POSITION: absolute; TOP: 60px">Suivi d'activité</span>
<span id="Label2"/span> style="font-weight: bold;Z-INDEX: 101; LEFT: 400px; POSITION: absolute; TOP: 144px">Date de fin :</span>
< input name="DateDebut" type="text" value="06/08/2021" readonly="readonly" id="DateDebut" style="Z-INDEX: 102; LEFT: 128px; POSITION: absolute; TOP: 168px" />
< input name="DateFin"/span> type="text" value="06/08/2021" readonly="readonly" id="DateFin"/span> style="Z-INDEX: 103; LEFT: 400px; POSITION: absolute; TOP: 168px" />
< input type="submit" name="btn_ChoixDebut" value="Choix" id="btn_ChoixDebut" class="MyBoutonChoix" style="width: 80px;Z-INDEX: 106; LEFT: 288px; POSITION: absolute; TOP: 168px"/span> />
< input type="submit" name="btnChoixFin" value="Choix" id="btnChoixFin" class="MyBoutonChoix" style="width: 80px;Z-INDEX: 104; LEFT: 560px; POSITION: absolute; TOP: 168px"/span> />
< table class="MyDatagrid"/span> cellspacing="0" rules="all" border="1" id="dgMainGrid"/span> style="border-style: Solid;width:824px;border-collapse:collapse;Z-INDEX: 107; LEFT: 128px; POSITION: absolute; TOP: 240px">
<tr class="MyDatagridHeader"/span>>
<td>日期</td>td> Cartons STD / CAO</td>< td>Palettes STD / CAO</td> <td>Dévoyé STD / CAO< /td><td> Tonnage STD / CAO</td>< td>Lignes STD / CAO</td>
</tr>< tr class="MyDatagridItem">
<td>/span>vendredi 06/08/2021< /td><td> 216 / 0</td>< td>29 / 0</td> <td>23 / 0< /td><td> 3,39 / 0</td>< td>1078 / 0</td>
</tr>/span>
</table>/span>
< input type="submit" name="btn_Resultat" value="Resultat" id="btn_Resultat" class="MyBoutonResultat" style="Z-INDEX: 109; LEFT: 665px; POSITION: absolute; TOP: 168px" /></form>
</body>
</HTML>
<iframe name="sif3" sandbox="allow-forms allow-modals allow-scripts" class="snippet-box-edit snippet-box-result" frameborder="0"></iframe>
編輯:正如你們中的一些人所說的,是的,即使使用 "好的 "日期格式,它仍然不作業,我認為這是因為 "輸入 "欄位不是真正用于輸入,它們只是顯示選定的日期,實際上日期是從日歷上取的。這就是為什么即使是好的日期格式,它也告訴我我沒有輸入任何日期
。編輯2:添加代碼 我找不到解決辦法,你有什么想法嗎? 謝謝你的閱讀,祝你有美好的一天! (對不起,我的英語不好)
uj5u.com熱心網友回復:
當我按下 "Choix "按鈕時,有一個事件被觸發,它使這個函式出現在代碼中<script type="text/javascript"/span>>
<!--
var theForm = document.forms['Form1'];.
if (!theForm) {
theForm = document.Form1;
}
function __doPostBack(eventTarget, eventArgument) {
if (!theForm.onsubmit || (theForm.onsubmit() != false) {
theForm.__EVENTTARGET.value = eventTarget;
theForm.__EVENTARGUMENT.value = eventArgument;
theForm.submit()。
}
}
// -->
</script>
然后我只需將 "Calendar1 "或 "Calendar2 "作為eventTarget,將日期(java格式)作為eventArgument發送給__doPostBack函式,就像這樣:
Set currentWdw = .document.fatherWindow
With currentWdw
Application.Wait Now TimeValue("0:00:01"/span>)
.execScript ("__doPostBack('Calendar1','" & datesail & ')")
Application.Wait Now TimeValue("0:00:01"/span>)
.execScript ("__doPostBack('Calendar2','" & datesail & "')")
結束 與
這是一個非常特殊的案例,但我希望這個答案能夠幫助到未來的人。
祝您愉快!
轉載請註明出處,本文鏈接:https://www.uj5u.com/houduan/320197.html
標籤:


