Re: [請益] 請問VBA將網頁下拉的寫法

Sub OpenAndScrollChrome()

'啟動Chrome瀏覽器
Shell "C:\Program Files\Google\Chrome\Application\chrome.exe"

'等待Chrome開啟
Application.Wait (Now + TimeValue("00:00:05"))

'模擬下箭頭鍵
Application.SendKeys "{DOWN 5}", True

'等待30秒
Application.Wait (Now + TimeValue("00:00:30"))

'關閉當前網頁（Ctrl+W）
Application.SendKeys "^{w}", True

End Sub
-----
Sent from JPTT on my iPhone

--
Every man for himself and God against them all.

--

試試看 For i = 1 To 5 Application.SendKeys "{DOWN}", True Application.Wait (Now + TimeValue("00:00:01")) Next i Chrome要是目前活動窗口 不然指令會被送到別的地方