請教板上各為高手,如果要用excel抓取網路即時資料,跨隔日的要如何製作??謝謝要從下午1點到次日2點,是這樣寫嗎?Sub ()Set MyBook = ThisWorkbookSet Sht1 = MyBook.Sheets("Sheet1")If Now >= (Today() + 0 + TimeValue("13:00:00")) And Now <= (Today() + 1 + TimeValue("02:00:10")) ThenEnd IfEnd Sub