You need to enable JavaScript to run this app. 如何用VBA Selenium修改Check24网站的日期选择器日期?
优惠活动
大模型
产品
解决方案
定价
更多

如何用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

相关产品推荐
方舟 Agent Plan

超全模态模型 × Harness 升级,最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列、Doubao-Seedream-5.0-pro、Kimi-K3 (部分), 限时 9.9 元起

最近更新时间:2026.08.20 07:24:25