(不定期更新)使用VBA解決 excel web 查詢無法匯入、匯入太慢的股市資料

ifye wrote:
目前chrome版本是141.0.7390.55
chrome driver版本是141.0.7390.54 (r1509326)
請問這裡driver應該是有相容chrome吧?

'chrome 141.0.7390.55
'chrome driver 141.0.7390.54 (r1509326) (x64)

Sub chromedrivertest()

    Dim chrome As New Selenium.ChromeDriver, UrL As String
    
    
    UrL = "https://www.mobile01.com/topicdetail.php?f=511&t=4737630&p=156"
    chrome.Get UrL
    chrome.Wait 10000
 
 
 
    chrome.Quit
    Set chrome = Nothing

End Sub

ifye wrote:
就沒辦法正確跑到想要的網址會停留在新分頁

Sub test()

    Dim Chrome As New Selenium.ChromeDriver

    Chrome.AddArgument ("user-data-dir=C:\Users\使用者名稱\AppData\Local\Google\Chrome\chromedriver")
   
    Chrome.Get "https://reurl.cc/2LmpVn"
    Stop

    Chrome.Wait 3000
    Chrome.Quit
    Set Chrome = Nothing
    
End Sub