- ©«¤l
- 218
- ¥DÃD
- 73
- ºëµØ
- 0
- ¿n¤À
- 290
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN10
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2014-5-19
- ³Ì«áµn¿ý
- 2022-11-29
|
½Ð°Ý¦p¦óÅý¥H¤Uµ{¦¡½X¡A°õ¦æ¨ìÀɮפU¸üªº®ÉÔ¡A¦Û°ÊÀx¦sÀɮצܦP¸ê®Æ§¨¨Ã«O«ùìÀɦW.csvÀÉ(¤U¸üÀɮ׬°.csvÀÉ)
Sub ¬d¸ß¨C¤é¼Æ¾Ú¨Ã¤U¸üÀÉ®×()
Dim indexer As Integer
indexer = 6656 + Day(Now()) - 23
Set myIE = CreateObject("InternetExplorer.Application")
With myIE
.Visible = true
.Navigate "http://xxxxxxxxxxxx/xxx.aspx" '¬d¸ß¼Æ¾Úºô§}
Do While .ReadyState <> 4
DoEvents
Loop
.Navigate "javascript:__doPostBack('ct600$phCondition3$cldDate','" & indexer & "')"
Application.Wait Now + 2 / 86400 'µ¥«Ý2¬í
.document.forms(0).all("ct600_btnConfirm").Click 'ÂI¿ï¬d¸ß«ö¶s
.Navigate "http://10.178.1.140:8023/ReportPage/ReportAgentToDay_28_tptv.aspx" '¬d¸ß¼Æ¾Ú·|¦Û°Ê²£¥Í©ó¦¹ºô§}¶±
Do Until .ReadyState = 4
DoEvents
Loop
.document.forms(0).all("ctl00_btnDownload").Click 'ÂI¿ï¤U¸ü«ö¶s
'ÂI¿ï¤U¸ü«ö¶s«á¡Aºô¶·|¼u¥X¤U¸üÀÉ®×µøµ¡¡A¸ß°Ý"¶}±ÒÂÂÀÉ"¡B"Àx¦s"¡B"¨ú®ø"¿ï¶µ
'§Æ±æ¯à¦Û°ÊÀx¦s¦Ü¦P¸ê®Æ§¨¨Ã«O«ùìÀɦW.csvÀÉ(¤U¸üÀɮ׬°.csvÀÉ)
'½Ð°Ý¥H¤W³o¬qµ{¦¡½X¸Ó«ç»ò¼g©O¡H
End With
End Sub
|
|