如何用VBA Selenium修改Check24网站的日期选择器日期?
解决Check24度假网站出发日期设置问题
问题背景
我需要修改Check24度假网站的出发日期为明年夏天的某个未来日期,但输入框没法直接编辑,必须通过日期选择器弹窗操作。之前尝试用VBA Selenium结合JavaScript修改属性没成功,相关网页HTML和我写的VBA代码如下:
网页HTML代码:
<div class="c24-travel-input-wrapper"><div class="c24-travel-tablet-input-overlay c24-travel-filled">Sa, 10.09.2022</div> <input type="text" name="departureDate" data-package-date="10.09.2022" data-lastminute-date="10.09.2022" data-earlybird-date="31.12.2022" data-hotelonly-date="10.09.2022" data-allinclusive-date="10.09.2022" data-train-date="12.09.2022" data-user-package-date="" data-user-lastminute-date="" data-user-earlybird-date="" data-user-hotelonly-date="" data-user-allinclusive-date="" data-user-train-date="" data-valid-query-date="" data-param-map="departureDate" placeholder="tt.mm.jjjj" data-validate-ele="1" id="c24-travel-departure-date-element" data-default-searchrequest-value="16.09.2022" data-saved-date="" tabindex="" data-defaultvalue="" class="c24-travel-validate-ele" value=""><div class="c24-travel-departure-date-element-description c24-travel-date-element-description c24-travel-hidden" id="c24-travel-departure-date-element-description">01.01.</div><span class="c24-travel-icon-date c24-travel-input-icon c24-travel-date-btn"></span></div>
我尝试的VBA代码:
Dim ch As Selenium.ChromeDriver Dim setDate As Selenium.WebElement Dim attrScript As String attrScript = "arguments[0].setAttribute(" & myTravelDateS & ")" 'myTravelDateS is set earlier - example is So, 01.01.2023 ch.ExecuteScript attrScript, setDate
之前代码的问题
你写的JavaScript语法错了:setAttribute需要两个参数(属性名和属性值),但你只传了日期字符串,没指定要修改的属性;另外也没定位到正确元素,更没触发日期变更后的页面事件,所以网站根本没识别到修改。
可行解决方案
方案1:模拟真实操作日期选择器(推荐,稳)
完全模拟用户点击选择器、切换年月、点选日期的流程,不容易触发网站反爬或校验:
Sub SetCheck24DepartureDate() Dim ch As New Selenium.ChromeDriver Dim targetDate As Date Dim targetDay As Integer, targetMonth As Integer, targetYear As Integer Dim datePickerBtn As WebElement Dim monthYearElement As WebElement Dim nextMonthBtn As WebElement Dim dateElements As WebElements Dim dateElement As WebElement ' 设置目标日期(示例:2024年7月15日) targetDate = DateSerial(2024, 7, 15) targetDay = Day(targetDate) targetMonth = Month(targetDate) targetYear = Year(targetDate) ' 启动浏览器开页面 ch.Start "chrome" ch.Get "https://urlaub.check24.de/" ' 等加载完,点日期选择器开弹窗 Set datePickerBtn = ch.FindElementByCss(".c24-travel-date-btn", timeout:=10000) datePickerBtn.Click ' 切换到目标年月 Do Set monthYearElement = ch.FindElementByCss(".c24-calendar-header-month", timeout:=5000) ' 解析当前显示的年月(网站是德语月份,要对应转数字) Dim currentMonthName As String, currentYearStr As String currentMonthName = Split(monthYearElement.Text, " ")(0) currentYearStr = Split(monthYearElement.Text, " ")(1) Dim currentMonth As Integer Select Case currentMonthName Case "Januar": currentMonth = 1 Case "Februar": currentMonth = 2 Case "März": currentMonth = 3 Case "April": currentMonth = 4 Case "Mai": currentMonth = 5 Case "Juni": currentMonth = 6 Case "Juli": currentMonth = 7 Case "August": currentMonth = 8 Case "September": currentMonth = 9 Case "Oktober": currentMonth = 10 Case "November": currentMonth = 11 Case "Dezember": currentMonth = 12 End Select Dim currentYear As Integer currentYear = CInt(currentYearStr) ' 没到目标年月就点下月按钮 If currentYear < targetYear Or (currentYear = targetYear And currentMonth < targetMonth) Then Set nextMonthBtn = ch.FindElementByCss(".c24-calendar-header-next") nextMonthBtn.Click Wait 1 ' 等切换动画完成 Else Exit Do End If Loop ' 选目标日期 Set dateElements = ch.FindElementsByCss(".c24-calendar-day:not(.c24-calendar-day-disabled)") For Each dateElement In dateElements If CInt(dateElement.Text) = targetDay Then dateElement.Click Exit For End If Next ' 验证结果 Wait 2 Dim dateOverlay As WebElement Set dateOverlay = ch.FindElementByCss(".c24-travel-tablet-input-overlay") Debug.Print "当前设置的出发日期:" & dateOverlay.Text ' 后续操作自己加... ' 用完关浏览器 ' ch.Quit End Sub ' 自定义等待函数 Sub Wait(seconds As Integer) Dim startTime As Double startTime = Timer Do While Timer < startTime + seconds DoEvents Loop End Sub
方案2:JS修改属性+触发事件
不想模拟点击的话,直接改元素的所有相关data-*属性,再触发页面监听的事件,确保网站识别到变更:
Sub SetDateViaJS() Dim ch As New Selenium.ChromeDriver Dim targetDateStr As String Dim dateElement As WebElement ' 目标日期要匹配网站显示格式(比如 "Mo, 15.07.2024") targetDateStr = "Mo, 15.07.2024" ' 纯日期格式(给data属性用) Dim pureDateStr As String pureDateStr = "15.07.2024" ch.Start "chrome" ch.Get "https://urlaub.check24.de/" ' 定位日期输入框 Set dateElement = ch.FindElementById("c24-travel-departure-date-element", timeout:=10000) ' 执行JS修改所有相关属性 ch.ExecuteScript "arguments[0].setAttribute('data-package-date', arguments[1]);", dateElement, pureDateStr ch.ExecuteScript "arguments[0].setAttribute('data-lastminute-date', arguments[1]);", dateElement, pureDateStr ch.ExecuteScript "arguments[0].setAttribute('data-hotelonly-date', arguments[1]);", dateElement, pureDateStr ch.ExecuteScript "arguments[0].setAttribute('data-allinclusive-date', arguments[1]);", dateElement, pureDateStr ' 修改显示层文本 ch.ExecuteScript "document.querySelector('.c24-travel-tablet-input-overlay').textContent = arguments[0];", targetDateStr ' 触发输入事件,让页面识别变更 ch.ExecuteScript "arguments[0].dispatchEvent(new Event('input'));", dateElement ' 验证结果 Wait 2 Debug.Print "设置后的日期显示:" & ch.FindElementByCss(".c24-travel-tablet-input-overlay").Text ' 后续操作自己加... ' ch.Quit End Sub
注意事项
- 方案1更稳定,完全贴合用户行为,不会被网站前端校验拦截;
- 方案2必须改全所有相关
data-*属性,还要触发事件,不然页面不认; - 网站月份是德语名称,要对应转成数字才能正确切换年月;
- 操作时一定要加等待,避免页面没加载完就执行下一步。
内容的提问来源于stack exchange,提问作者Mark Brown
相关产品推荐
相关产品推荐

