µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Excelµ{¦¡°Ï
» Jspºô¶À³¸Ó¦p¦ó¿ï¾Ü¨ä¥L¥\¯àªººô¶-«PO
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
[µo°Ý]
Jspºô¶À³¸Ó¦p¦ó¿ï¾Ü¨ä¥L¥\¯àªººô¶-«PO
smart3135
µoµu®ø®§
¥[¬°¦n¤Í
smart3135
·í«eÂ÷½u
UID
16988
©«¤l
96
¥DÃD
18
ºëµØ
0
¿n¤À
125
ª÷¿ú
125
ÂI¦W
0
§@·~¨t²Î
Windows 7
³nÅ骩¥»
Office 2007
¾\ŪÅv
20
©Ê§O
¨k
¦b½u®É¶¡
190 ¤p®É
µù¥U®É¶¡
2014-3-23
³Ì«áµn¿ý
2022-8-2
¤¤¾Ç¥Í
©«¤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
1
#
¸õÂà¨ì
»
¥¿§Ç¬Ý©«
¥´¦L
¦rÅé¤j¤p:
t
T
µoªí©ó 2020-1-18 05:57
|
¥u¬Ý¸Ó§@ªÌ
[µo°Ý]
Jspºô¶À³¸Ó¦p¦ó¿ï¾Ü¨ä¥L¥\¯àªººô¶-«PO
¥»©«³Ì«á¥Ñ smart3135 ©ó 2020-1-18 06:02 ½s¿è
¤£¦n·N«ä¡A«e¤@½gPO¤å¦]¨Ï¥Î¤â¾÷µo¤å¤£¤è«K¡A¥¼¯à¸Ôz¡A©Ò¥H¥Î¹q¸£«·sPO¤@¦¸
½Ð±Ð¤@¤U¦U¦ìVBA°ª¤â¡A¥Ø«e§Ú·Q§Q¥Î¤½¥qºô¶°µ¤@¨Ç¦Û°ÊÂ^¨ú¼Æ¾Úªº°Ê§@
¥Ñ©ó¤½¥qºô¶¬OJsp¡A·Q¦b¦P¤@Óºô¶¿ï¾Ü¥t¤@Ó¥\¯à¿ï¶µ¡A¦ýºô§}¬O¤@¼Ëªº
§Ú§Æ±æ¥i¥Hª½±µ³s¨ì¹Ï2¡A¦ý¼g¤Uªºµ{¦¡½X³£¬Oª½±µ³s¨ì¹Ï1
¬Ý¤F¤@¤U¹Ï2ªºì©l½X¡A¤£ª¾¹D¬O¤£¬O¥i¥H³z¹Lì©l½X¤¤ªºÃöÁä¦r¼g¥Xª½±µ³sµ²¨ì¹Ï2¥\¯àªºµ{¦¡½X
Àµ½Ð¦U¦ì°ª¤â«üÂI¤@¤U¡A©Î¬O¦³¬ÛÃö½d¨Ò¥i´£¨Ñ°Ñ¦Ò¬ã¨s¡A¸U¤À·PÁ¡C
PS¡G¥Ñ©ó¤½¥qºô¶¥u¯à¦b¤½¥q¶}±Ò»P¤½¥q«O±K±ø´Ú¡AµLªk¨Ñ¦U¦ì°ª¤â¶}±Òºô¶´ú¸Õ¡AÁٽШ£½Ì¡C
¹Ï1
¤U¸ü
(73.86 KB)
2020-1-18 05:56
¹Ï2
¤U¸ü
(127.01 KB)
2020-1-18 06:01
Sub test()
Set IE = CreateObject("InternetExplorer.Application")
With IE
.Visible = False
.Navigate "http://XXXXXXX/WipTxnManager/jsp/index.jsp"
Do While .Busy Or .ReadyState <> 4: DoEvents: Loop
End With
End Sub
½Æ»s¥N½X
¼Ó¥D¼ö©«
¥i§_¥Î°j°é©ÎÅܼƶפJ¤j¶q¸ê®Æ¡H
¦p¦ó¥ÎEXCEL VBA¦bCHROME¿é¤J¸ê®Æ¦A«ö¤U¬d¸ß
¥ÎVBA§ìÃÒ¥æ©Ò¸ê®Æ°ÝÃD
Microsoft Excel¥¿¦bµ¥«Ý¨ä¥LÀ³¥Îµ{¦¡§¹¦¨O
IE¤w³]©w.Visible¤´¸õ¥Xºô¶
¤À¨É¤@Ó·s¤â¾Ç²ßVBAªººô§}
¦p¦ó¥ÎVBA§ä¥X¹ïÀ³Ä檺ȡH
VBA¯à±q°õ¦æ¤@Ó¥¨¶°¤¤¸õ¨ì¥t¤@Ó¥¨¶°¶Ü?
on error resume next¥d¦bµL°j°é
¦p¦ó¥ÎVBA¤U¸üÃÒ¥æ©Ò¨C¤éªº¤T¤jªk¤H¶R½æ°O¿ý
¦¬ÂÃ
¤À¨É
ÀR«ä¦Û¦b :
¤f»¡¤@¥y¦n¸Ü¡A¦p¤f¥X½¬ªá¡F¤f»¡¤@¥yÃa¸Ü¦p¤f¦R¬r³D¡C
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
EXCEL±MÄÝ°Q½×°Ï
Excel£¸¯ë°Ï
Excelµ{¦¡°Ï
¶i¶¥À³¥Î±M°Ï
OFFICE ¨t¦C
Word
PowerPoint
Access
Office¤£¤À°Ï
µ{¦¡»y¨¥
VB »P VB.Net
C »P C#
Java »P J#
µ{¦¡³]p¤£¤À°Ï
¸ê®Æ®w
ORACLE
My SQL
MS SQL
ºô¶³]p
ASP »P ASP.NET
PHP
PHP+MySQL ¤Jªù¹ê§@
JavaScript
FLASH / ActionScript
HTM/ HTML/ CSS
ºô¶³]p¤£¤À°Ï
¹q¸£»P§@·~¨t²Î
¹q¸£¦UºØµwÅé°Q½×
¤@¯ë¹q¸£³nÅé°Q½×
½×¾Â¨Æ°È
ºÞ²z¤½§i
§ë¶D¤Ï¬M
·s¤â´ú¸Õ
·R ¡E ¥Í¬¡
¤½¯q§G§iÄæ
¥Í¬¡»P·P°Ê
[¦¬Âæ¹¥DÃD]
[Ãöª`¦¹¥DÃDªº·s¦^´_]
[³q¹L QQ¡BMSN ¤À¨Éµ¹ªB¤Í]
¥Ó½Ð¤Í±¡Ãì±µ
Facebook¯»µ·