µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Excelµ{¦¡°Ï
» ºô¶ªº¤U©Ô¿ï³æn¦p¦ó±±¨î?
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
[µo°Ý]
ºô¶ªº¤U©Ô¿ï³æn¦p¦ó±±¨î?
PKKO
µoµu®ø®§
¥[¬°¦n¤Í
PKKO
(PKKO)
·í«eÂ÷½u
UID
14751
©«¤l
549
¥DÃD
152
ºëµØ
0
¿n¤À
691
ª÷¿ú
691
ÂI¦W
0
§@·~¨t²Î
WIN7
³nÅ骩¥»
OFFICE 2010
¾\ŪÅv
50
©Ê§O
¨k
¦b½u®É¶¡
506 ¤p®É
µù¥U®É¶¡
2013-8-10
³Ì«áµn¿ý
2022-9-7
¡@¼ÊºÙ:
PKKO
°ª¤¤¥Í
©«¤l
549
¥DÃD
152
ºëµØ
0
¿n¤À
691
ÂI¦W
0
§@·~¨t²Î
WIN7
³nÅ骩¥»
OFFICE 2010
¾\ŪÅv
50
©Ê§O
¨k
µù¥U®É¶¡
2013-8-10
³Ì«áµn¿ý
2022-9-7
1
#
¸õÂà¨ì
»
¥¿§Ç¬Ý©«
¥´¦L
¦rÅé¤j¤p:
t
T
µoªí©ó 2017-1-7 01:09
|
¥u¬Ý¸Ó§@ªÌ
[µo°Ý]
ºô¶ªº¤U©Ô¿ï³æn¦p¦ó±±¨î?
¤@¯ëºô¶ªºtextbox´N¥Îvalue°µ¿é¤J,button´N¥Îclick¥hÂI®×
¦ý¤U©Ô¿ï³æn¦p¦ó±±¨î©O?
§Ú¥Ø«e¥i¥H±N¤U©Ô¿ï³æ¶i¦æ¿é¤J,¦ý¦pªG¬O¤HÂI®×ªº¸Ü¤U©Ô¿ï³æ·|±q¹Ï¤@Åܦ¨¹Ï¤G
¤U¸ü
(11.11 KB)
2017-1-7 01:03
¤U¸ü
(16.34 KB)
2017-1-7 01:03
¥i¬O§Ú¥Î¤U¦Cµ{¦¡½X¶i¦æ¿é¤J¤§«á¥u·|¦³¹Ï¤@,¤£·|Åܦ¨¹Ï¤G
'µ{¦¡½Xªºvalue¿é¤Jdsheet_qty ¤§«á,¤Ï¦Ó¤U©Ô¿ï³æ·|¥X²{§Únªº(¥Zµn¼Æ¶q),Yª½±µ¿é¤J¤Ï¦Ó¤£¦æ,§Ú¤]¤£ª¾¹D¬°¤°»ò
For Each e In ie.document.GetElementsByTagName("select")
If e.textContent Like "*¤@«ö¸Ñ¨M*" Then
e.Value = "dsheet_qty"
End If
Next
½Æ»s¥N½X
¦ý«ÂI¬O¨S¦³¥X²{¹Ï¤G§Ú¥i¥Hª½±µ¿é¤J¥t¥~¨âÓ¤U©Ô¿ï³æªºÈ¶Ü?
¥H¤Î¥t¥~¨âÓ¤U©Ô¿ï³æ§Ún¦p¦ó¿é¤J?
¤U¹Ï¦³¸Ó¤U©Ô¿ï³æªººô¶¤¸¯À,§Úªº¬Ooption 7 ,¦ý§Ú¤£ª¾¹Dn¦p¦ó¿é¤JÅý¥Lª½±µ¸õ¨ì7?
¤U¸ü
(111.43 KB)
2017-1-7 01:08
¤£¦n·N«ä¤S³Â·Ð¦U¦ì¤j¤j¤F!
¼Ó¥D¼ö©«
¦p¦ó¥Îvbaª¾¹D§@¥ÎÀx¦s®æ&Äæ&¦Cªº¦ì¸m
ExcelÀɮצ³¿ìªk¨¾¤î§O¤H½Æ»s±NÀÉ®×±a¨«¶Ü?
Userform³Ì¤j¤Æ(¥B¤º®e¤ñ¨Ò¦Û°Ê©ñ¤j?)
¦p¦ó²¾°£°}¦C¤º«½Æªº³¡¤À(STRING)
¦³¤Hª¾¹D¥ß¬W¸I¸Ó«ç¼Ëpºâ¶Ü?(±Æ¦C²Õ¦X°ÝÃD
§A¶}±ÒÀɮ׮ɷ|°Ý§A¬O§_n§ó·s¶Ü?¤À¨É¨ú®ø³s
¦p¦ó³z¹LVBAÀH¾÷"¸U¤¤¨ú¤@"(¦ý¤£¯à«½Æ),©â
³Ì§Ö³tªº¤ñ¹ï¸ê®Æ¤è¦¡?
vba¥i§_¤£¥´¶}excelªí§Y¥iª¾¹Da1ªºÈ?
20Ó¬Û¦P¥\¯àComboBox¦p¦ó¥i¥H¬Ù¤u¼¶¼g?
¦¬ÂÃ
¤À¨É
PKKO
stillfish00
µoµu®ø®§
¥[¬°¦n¤Í
stillfish00
·í«eÂ÷½u
UID
9276
©«¤l
1018
¥DÃD
15
ºëµØ
0
¿n¤À
1058
ª÷¿ú
1058
ÂI¦W
0
§@·~¨t²Î
win7 32bit
³nÅ骩¥»
Office 2016 64-bit
¾\ŪÅv
50
©Ê§O
¨k
¨Ó¦Û
®ç¶é
¦b½u®É¶¡
1141 ¤p®É
µù¥U®É¶¡
2012-5-9
³Ì«áµn¿ý
2022-9-28
¤j¾Ç¥Í
©«¤l
1018
¥DÃD
15
ºëµØ
0
¿n¤À
1058
ÂI¦W
0
§@·~¨t²Î
win7 32bit
³nÅ骩¥»
Office 2016 64-bit
¾\ŪÅv
50
©Ê§O
¨k
¨Ó¦Û
®ç¶é
µù¥U®É¶¡
2012-5-9
³Ì«áµn¿ý
2022-9-28
4
#
µoªí©ó 2017-1-18 09:16
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
1#
PKKO
http://forum.twbts.com/viewthread.php?tid=13209
ªí¹F¤£²M¡BÃD·N¤£©ú½T¡B¨SªþÀɮ׮榡¡B¨S¦³°Q½×°ÝÃDªººA«×~~~~~~¥H¤W·R²ö¯à§U¡C
TOP
PKKO
µoµu®ø®§
¥[¬°¦n¤Í
PKKO
(PKKO)
·í«eÂ÷½u
UID
14751
©«¤l
549
¥DÃD
152
ºëµØ
0
¿n¤À
691
ª÷¿ú
691
ÂI¦W
0
§@·~¨t²Î
WIN7
³nÅ骩¥»
OFFICE 2010
¾\ŪÅv
50
©Ê§O
¨k
¦b½u®É¶¡
506 ¤p®É
µù¥U®É¶¡
2013-8-10
³Ì«áµn¿ý
2022-9-7
¡@¼ÊºÙ:
PKKO
°ª¤¤¥Í
©«¤l
549
¥DÃD
152
ºëµØ
0
¿n¤À
691
ÂI¦W
0
§@·~¨t²Î
WIN7
³nÅ骩¥»
OFFICE 2010
¾\ŪÅv
50
©Ê§O
¨k
µù¥U®É¶¡
2013-8-10
³Ì«áµn¿ý
2022-9-7
3
#
µoªí©ó 2017-1-17 13:58
|
¥u¬Ý¸Ó§@ªÌ
¥Ñ©ó¤£ª¾¹D¦p¦ó«ö¤U¸Ó¤U©Ô¿ï³æ,¦]¦¹§Ú¥Î¼ÒÀÀÁä½Lªº¤è¦¡§¹¦¨¤F
¤£¹L§ÚÁÙ¬O«Ü¦n©_,¨ì©³n¦p¦óÂI¥X¸Ó¤U©Ô¿ï³æ©O?
.click .select .dropclick §Ú³£¸Õ¹L¤F,´N¬O¤£·|¥X²{¤U©Ô¿ï³æ
¦ý§Ú¼ÒÀÀÁä½L¥Îdownªº®×¥ó´N¥i¥H¥X²{¤U©Ô¿ï³æ= =?
Application.SendKeys "{TAB}", True
Application.SendKeys "{TAB}", True
Application.SendKeys "{TAB}", True
Application.Wait Now + TimeValue("00:00:01")
Application.SendKeys "{DOWN}", True
Application.SendKeys "{DOWN}", True
Application.SendKeys "{DOWN}", True
Application.SendKeys "{DOWN}", True
Application.SendKeys "{DOWN}", True
Application.SendKeys "{DOWN}", True
Application.SendKeys "{DOWN}", True
Application.Wait Now + TimeValue("00:00:01")
Application.SendKeys "{TAB}", True
Application.SendKeys "{TAB}", True
Application.Wait Now + TimeValue("00:00:01")
Application.SendKeys "+", True
Application.SendKeys 1
ie.document.GetElementByID("jqizoo_state0_button§ó·s¤Î¦P¨B").Click
½Æ»s¥N½X
PKKO
TOP
PKKO
µoµu®ø®§
¥[¬°¦n¤Í
PKKO
(PKKO)
·í«eÂ÷½u
UID
14751
©«¤l
549
¥DÃD
152
ºëµØ
0
¿n¤À
691
ª÷¿ú
691
ÂI¦W
0
§@·~¨t²Î
WIN7
³nÅ骩¥»
OFFICE 2010
¾\ŪÅv
50
©Ê§O
¨k
¦b½u®É¶¡
506 ¤p®É
µù¥U®É¶¡
2013-8-10
³Ì«áµn¿ý
2022-9-7
¡@¼ÊºÙ:
PKKO
°ª¤¤¥Í
©«¤l
549
¥DÃD
152
ºëµØ
0
¿n¤À
691
ÂI¦W
0
§@·~¨t²Î
WIN7
³nÅ骩¥»
OFFICE 2010
¾\ŪÅv
50
©Ê§O
¨k
µù¥U®É¶¡
2013-8-10
³Ì«áµn¿ý
2022-9-7
2
#
µoªí©ó 2017-1-15 13:39
|
¥u¬Ý¸Ó§@ªÌ
¸Ó¤U©Ô¿ï³æªºÄݩʦp¤U,½Ð°Ýn¦p¦óÂIÀ»¥L,Åý¥L¥X²{³\¦h¿ï³æ©O?
§Úª½±µµ¹¤©È(dsheet_qty)ºô¶·|Åܦ¨¥Zµn¼Æ¶q,¦ý¬O¥t¥~¨âÓ¤U©Ô¿ï³æ³£¤£·|¥X²{
¥u¦³ì¥»ªº²Ä¤@Ó¤U©Ô¿ï³æ¦³¥X²{¦Ó¤w...
tagname=SELECT
ID=listbfield
name=listbfield
value=dsheet_qty
type=select-one
PKKO
TOP
ÀR«ä¦Û¦b :
§ÚÌn°µ¦nªÀ·|ªºÀô«O¡A¤]n°µ¦n¤º¤ßªºÀô«O¡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¯»µ·