ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[­ì³Ð] ¶°«O¸ê®Æ(§ïª©«á)

Dear iamaraymond ¤j¡A

¦³¬Ý¨ì¨â­Ó°ÝÃD¡A¤£¾å±o¨ä¥L¤H¬O§_¤]¹J¨ì:
1.  ¤é´Áªº³¡¤À§A§ì¤U¨Ó«á©ñ¦bA1, B1, C1.......¡A¨Ã¤£¬O©ñ¦b¨C¥÷¸ê®Æªº¤W¤è¡A¤£¹L·å¤£±»·ì¡A¬Ý¤@¤U´NÀ´¤F¡C
2.  ·í«ö¤U Run«á¡A·|¥X²{°õ¦æ¶¥¬q¿ù»~°T®§¨Ã«ü¦V©ó (.send "REQ_OPR=qrySelScaDates")¡A©ó¬O§Ú¦b¶}ÀYªº¦ì¸m¼g¤J¤F On Error Resume Next ¡A¤§«á´N¥¿±`¤F¡A¤£¾å±o·|¦³«á¿ò¯g¶Ü?

ÁÙ¦³­Ó¤p°ÝÃD·Q°Ý¤@¤U¡A
½Ð°Ý§Ú·Q¸õµÛ§ì¸ê®Æ¡A¨Ò¦p:¨â¬P´Á§ì¤@µ§¡A¤£¾å±o­n­×§ï­þ¸Ì?­Y¦³ªÅ¡A¦A½Ð«ü¾É¤@¤U¡CÁÂÁÂ~~

TOP

¸U¤À·PÁÂ~~

TOP

¦^´_ 3# cji3cj6xu6


¨Ò¦p»¡¥i¥H¦bB3Àx¦s®æ¿é¤JªÑ²¼¥N¸¹¡AµM«á«ü©wµ¹ÅܼơAªø³o¼Ë
stockno=[B3]
©Î¬O¥Îinputbox
stockno=inputbox("½Ð¿é¤JªÑ²¼¥N¸¹")

±µµÛ§â­ìµ{¦¡½Xªº²Ä32¦æ§ï¦¨
.send "scaDates=" & myDate & "&scaDate=" & myDate & "&SqlMethod=StockNo&StockNo=" & stockno & "&StockName=&REQ_OPR=SELECT&clkStockNo=" & stockno & "&clkStockName="
§â­ì¥»ªº2330¥ÎÅܼƨú¥N¡A°O±o¦r¦ê¸òÅܼƭn¥Î&³s±µ
Excel VBAºô­¶¸ê®Æ¦¬¶°±Ð¾Ç:
http://forum.twbts.com/thread-20848-1-1.html

TOP

¦^´_ 2# joey0415

·PÁ§Aªº¤À¨É¡A±z´£¨Ñªººô¯¸¯uªº«Ü´Î¡A¥u¬O¤p§Ì¯uªº«Ü¯Ê¥F¨C©P³£¥h§ì¸ê®Æªº¼Ý¤OXD
QueryTable¤]¤£¿ù¡A¦]¬°³o­Óºô¯¸¸ê®Æ¸û¤Ö¡A©Ò¥H¥i¥H°õ¦æ«Ü§Ö¡A¦ý¦pªG¸I¨ì«ÜÃe¤jªº¸ê®Æ®É¥i¯à´N·|¶]«Ü¤[¡A©Ò¥H¤£ª¾¤£Ä±´N¾i¦¨¥ÎXMLHTTP§ì¸ê®Æªº²ßºD¤F
Excel VBAºô­¶¸ê®Æ¦¬¶°±Ð¾Ç:
http://forum.twbts.com/thread-20848-1-1.html

TOP

¦³¬Ý¨ì¤F¡AÁÂÁÂ!!

¦ý½Ð°Ý¤@¤U­n¦p¦ó­×§ïªÑ²¼¥N¸¹¬°ÅܼÆ??

TOP

¦^´_ 1# iamaraymond

·PÁ±zªº¤À¨É¡A¦Û¤v¬P´Á¤Ñ¤]ªáÂI®É¶¡§ïµ{¦¡¡A¥ý§ä¤é´Á«á¡A¦A¨Ï¥Îquery table¤è¦¡§ì¨ú¡A±zªº¤è¦¡¤]¤£¿ù

´£¨Ñ¤@­Ó¤è¦V

https://data.gov.tw/dataset/11452

³oùØ´£¨Ñ¨C¶g©Ò¦³ªÑ²¼¤@°_¤U¸ü¡A¤£¹L­n¨C¶g§ì¨ú¡A¨S¦³¥H«eªº¸ê®Æ¡A¦pªG¤£«æªº¸Ü¡A¥Î³o­Óºô¯¸²Ö¿n¦Û¤vªº¸ê®Æ®w¤~¬O³Ì´Îªº¡A¨C¬P´Á¥u§ì¤@¦¸

TOP

        ÀR«ä¦Û¦b : ÁÀ¨¥¹³¤@¦·²±¶}ªºÂAªá¡A¥~ªí¬üÄR¡A¥Í©Rµu¼È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD