- ©«¤l
- 4
- ¥DÃD
- 2
- ºëµØ
- 0
- ¿n¤À
- 6
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office 2016
- ¾\ŪÅv
- 10
- µù¥U®É¶¡
- 2021-1-22
- ³Ì«áµn¿ý
- 2022-9-19
|
¤j®a¦n
¤p§Ì·Qn¥´¶}¤@Óie¡A¨Ã¥B¨C3¬í§ó·s³oÓºô¶
¦ýºô¶§ó·s1¦¸¥H«á
excel´N¸õ¥XµLªk°õ¦æ¥¨¶°timer ie
¸Ó¥¨¶°¥i¯àµLªk¦b¦¹¬¡¶Ã¯¨Ï¥Î¡A©Î¤w°±¥Î©Ò¥H¥¨¶°
±À´ú¬Otimer¸Ì±¦³¤Þ¼ÆªºÃö«Y
¦ý¨S¦³¤Þ¼Æ¡A½sĶ¾¹¤S·|»¡¨S¦³ª«¥ó
¥Îapplication.waitªº¸Ü§Ú§ó·sºô¶¥H«áÁÙn½Æ»s¶K¤WEXCEL
³o®ÉEXCEL·|°±¦í¡A¤]¤£¬O§Únªº
½Ð±Ð¤j®a¦³¨S¦³¤°»ò¤èªk¥i¥HÅýtimer¥¿±`¹B§@©O
µ{¦¡½X¦p¤U- Sub ºô¶§ó·s()
- Dim ie As Object
- Set ie = CreateObject("InternetExplorer.Application")
- With ie
- .Visible = True
- .navigate "www.google.com.tw"
- Do While .busy Or .readystate <> 4: DoEvents: Loop
- End With
-
- timer ie
-
- End Sub
- Public Sub timer(ie As Object)'¨S¦³¤Þ¥ÎIE»¡¨S¦³ª«¥ó
-
- With ie
- .Refresh
- Do While .busy Or .readystate <> 4: DoEvents: Loop
- End With
-
- alertTime = Now + TimeValue("00:00:10")
- Application.OnTime alertTime, "timer ie"'¤Þ¥Î¥H«á³o¸Ì´N¤£¦æ¤F
-
- End Sub
½Æ»s¥N½X |
|