µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Excelµ{¦¡°Ï
» VBA ÂI¿ï div class «ö¶s
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
[µo°Ý]
VBA ÂI¿ï div class «ö¶s
msmplay
µoµu®ø®§
¥[¬°¦n¤Í
msmplay
·í«eÂ÷½u
UID
17535
©«¤l
218
¥DÃD
73
ºëµØ
0
¿n¤À
290
ª÷¿ú
290
ÂI¦W
0
§@·~¨t²Î
WIN10
³nÅ骩¥»
Office2010
¾\ŪÅv
20
©Ê§O
¤k
¦b½u®É¶¡
177 ¤p®É
µù¥U®É¶¡
2014-5-19
³Ì«áµn¿ý
2022-11-29
¤¤¾Ç¥Í
©«¤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
1
#
¸õÂà¨ì
»
˧Ǭݩ«
¥´¦L
¦rÅé¤j¤p:
t
T
µoªí©ó 2018-6-14 13:37
|
Åã¥Ü¥þ³¡©«¤l
[µo°Ý]
VBA ÂI¿ï div class «ö¶s
½Ð°Ý¦p¦ó¥Hvbaµn¤Jºô¶«á¡AÂI¿ïºô¶³sµ²«ö¶s(¦@¨â¼h)¡A¦ý¦]ºô¶¬°¤½¥q¤ººôµLªk´£¨Ñ¡AÁٽкô¤jÀ°¦£¬Ý¬Ý¬O§_¦³¸Ñ¡AÁÂÁ¡C
(¥Ø«eµn¤Jºô¶¤w¾Ç·|¡A¦ýÂI¿ï«ö¶s´ú¸Õ¤@ª½¥¢±Ñ)
(¤½¥q¹q¸£win7¡BIE8(¨î¤É¯Å))
Dim p As Object
Set myIE = CreateObject("InternetExplorer.Application")
With myIE
.Visible = True
.Navigate "¤½¥qºô§}"
Do While Busy Or .ReadyState <> 4: DoEvents: Loop
Set p = .Document.all.tags("INPUT")
.Document.all.txtUsername.innerText = "xxxxxx" 'µn¤J±b¸¹
.Document.all.txtPassword.innerText = "xxxxxx" 'µn¤J±K½X
.Document.all.ImageButton2.Click 'µn¤J
Do While Busy Or .ReadyState <> 4: DoEvents: Loop
ÂI¿ï²Ä¤@¼h«ö¶s
ÂI¿ï²Ä¤G¼h«ö¶s
End With
²Ä¤@¼h«ö¶s
<div class="panel-header accordion-header" style="width: 163px; height: 15px;" jQuery1528952991125="290" sizcache="3" sizset="0">
<div class="panel-title panel-with-icon">
¤å¦r - ³B²z¤¤¤ß
¤U¸ü
(1.69 KB)
2018-6-14 13:36
¤U¸ü
(18.13 KB)
2018-6-14 13:36
²Ä¤G¼h«ö¶s
<a class="easyui-accordion-a" href="#" rel="../InboundTrace/CC_inboundRecordListNew.aspx" ref="439" jQuery1528952991125="201">
<span class="nav">
¤å¦r - ¨Ó¹q¤º®e°O¿ý(·s)
¤U¸ü
(8.17 KB)
2018-6-14 13:37
¤U¸ü
(16.65 KB)
2018-6-14 13:37
¼Ó¥D¼ö©«
vba¶}±Ò¨Ã§ì¨ú«ü©w¸ê®Æ§¨¤ºÃöÁä¦rÀÉ®×&¬¡¶
VBA¨Ì±ø¥ó¦Û°Ê¿z¿ï
EXCEL²¤Æ¤½¦¡°ÝÃD
VBA¦hÄæ¦Û°Ê¦V¤U¶ñº¡
¦sÀɮɦ۰ʳƥ÷ÀɮרÃÂର.xlsx®æ¦¡
vba§PÂ_¬O§_¤wµn¤Jºô¶
VBAÂI¿ïÀx¦s®æ«ü©w½d³ò¦Û°Ê¤Ï¦â
COUNTIFS²Îp½Æ¼Æ±ø¥ó°ÝÃD
¤ñ¹ï²Å¦XÃöÁä¦r¦ê±a¥X¹ïÀ³¸ê®Æ
Â^¨úÀx¦s®æ¤é´Á°ÝÃD
¦¬ÂÃ
¤À¨É
*¦v¤k¤@ªTµL»~*
ÀR«ä¦Û¦b :
¤Hn¦Û·R¡A¤~¯à·R´¶¤Ñ¤Uªº¤H¡C
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
Excel£¸¯ë°Ï
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¯»µ·