- ©«¤l
- 96
- ¥DÃD
- 18
- ºëµØ
- 0
- ¿n¤À
- 125
- ÂI¦W
- 0
- §@·~¨t²Î
- Windows 7
- ³nÅ骩¥»
- Office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2014-3-23
- ³Ì«áµn¿ý
- 2022-8-2
|
¦^´_ 4# joey0415
Joey¤j¡A¤£¦n·N«ä¡A¤£¬O«ÜÀ´±z³o¬qµ{¦¡½X¡A¤£ª¾¯à¤£¯à®M¥Î¦b§Úªºµ{¦¡½X©O¡H- Sub ¤u³æÁ`¼Æ¦^³ø()
- Set IE = CreateObject("InternetExplorer.Application")
- With IE
- .Visible = False
- .Navigate "¤½¥qºô§}"
- Do While .Busy Or .ReadyState <> 4: DoEvents: Loop
- With .Document
- .ALL("dFrom").Value = "2020/01/05" '¶}©l¤é´Á
- .ALL("dTo").Value = "2020/01/11" 'µ²§ô¤é´Á
- For Each E In .GetElementsBytagName("INPUT")
- If E.Value = "¬d¸ß" Then
- E.Click
- Exit For
- End If
- Next
- ' .ALL("¬d¸ß").Click '«ö¤U¬d¸ßÁä
- End With
- Do While .Busy Or .ReadyState <> 4: DoEvents: Loop
- .execwb 17, 2
- .execwb 12, 2
-
- With ActiveSheet
- .Cells.Delete
- .[a1].Select
- .PasteSpecial Format:="Unicode ¤å¦r", Link:=False, DisplayAsIcon:= _
- False, NoHTMLFormatting:=True
- End With
- End With
- End Sub
½Æ»s¥N½X |
|