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

¥ÎVBA§ìÃÒ¥æ©Ò¸ê®Æ°ÝÃD

¥ÎVBA§ìÃÒ¥æ©Ò¸ê®Æ°ÝÃD

¥»©«³Ì«á¥Ñ smart3135 ©ó 2014-9-24 20:29 ½s¿è

¦U¦ì¤j¤j¦n,¤p§Ì¦³¦Û¤v¼g¤F¤@­Ó§ìÃÒ¥æ©Ò½L«á¸ê®Æªº¦¬½L»ù©M¹sªÑ»ù,§ì¨ú¹sªÑ»ù¨S¦³°ÝÃD,¥i¬O¦b§ì¨ú¦¬½L»ù³£·|¹J¨ì¤@­Ó°ÝÃD
´N¬O¨C·í·í¤Ñ¦¬½L«á¦³·sªº¸ê®Æ®É,§Ú¥ÎVBA¥h§ì¼Æ¾Úªº®É­Ô´N·|¥X²{ERROR,§Ú¦³¥J²Ó¬Ý¹L§Ú¼gªººô§}¨Ã¨S¦³°ÝÃD
¦Ó¥B¥u­n¦b·í¤ÑÁÙ¥¼¦³·s¸ê®Æ¥X¨Ó«e,§ì¨ú¼Æ¾Ú³£¬O¥¿±`°õ¦æ¥¿±`¶]§¹,¦ý¥u­n¦³·s¸ê®Æ¥X¨Ó«á°õ¦æ´N·|ERROR
§Ú±N¬Û¦Pªººô§}½Æ»s¶K¤W§Úªºµ{¦¡½X¤¤,¦A§ì¨ú¼Æ¾Ú¤S«ì´_¥¿±`,¤£ª¾¹D¬°¤°»ò·|¥X²{³o¼Ëªºª¬ªp,¬O§_¬Oµ{¦¡½X¨S¦³¼g¦n©O?
¾Á½Ð¦U¦ì°ª¤â¤j¤j­Ì½ç±Ð,·P®¦
http://www.twse.com.tw/ch/trading/exchange/MI_INDEX/genpage/Report201409/A1122014092427.php?select2=27&chk_date=103/09/24
ªþ¤W·|¥X¿ùªºEXCELÀɤÎERROR¹Ï
error.jpg
test.zip (30.42 KB)

¦^´_ 1# smart3135
http://www.twse.com.tw/ch/trading/exchange/MI_INDEX/genpage/Report201409/A11220140924ALLBUT0999_1.php?select2=ALLBUT0999&chk_date=103/09/24
http://www.twse.com.tw/ch/trading/exchange/MI_INDEX/genpage/Report201409/A1122014092427.php?select2=27&chk_date=103/09/24

¤W­±¬O§Úªº¥i¥Î
¤U­±¬O§Aªº

TOP

¦^´_ 2# joey0415
¼Ó¤W¤j¤j,±z©Ò¶Kªººô¯¸©M§Úªº¬O¤@¼Ëªº,¥u¬O±z¿ï¾Üªº¬O¥þ³¡Ãþ§O(¤£§t¤û¡BºµÃÒ),¦Ó§Ú¿ï¾Üªº¬O³q°Tºô¸ô·~,ºô§}·|¦³¨Ç·L®t²§
¦ý³£¬O¨Ó¦ÛÃÒ¥æ©Òºô¯¸,¥t¥~¦A»¡©ú¤@¤U,¦bµo³o©«¤å¤§«e,§Ú¥Î§ÚªºVBAµ{¦¡°õ¦æ®É·|¥X²{¤W¹Ï¿ù»~,¥i¬O¦bµo¤å«á¤­¤ÀÄÁ
¦A¥Î¬Û¦PªºVBA°õ¦æ¤@¦¸,¥¼°µ¥ô¦ó­×§ï,«o¤S¥i¥H¥¿±`°õ¦æ,¤£ª¾¹D°ÝÃD¨s³º¥X¦b­þ?§Ú·|¦A§V¤O¬ã¨s¬Ý¬Ý,·PÁ±zªº¦^ÂÐ

TOP

¦^´_ 1# smart3135


   ¤j¤j¥i¥H¤À¨É§AªºÀÉ®×µ¹§Ú ¬Ý¬Ý¶Ü¡H

TOP

¦^´_ 2# joey0415


    ±z¦n,
    §Ú¥Î
http://www.twse.com.tw/ch/trading/exchange/MI_INDEX/genpage/Report201501/A11220150105ALLBUT0999_1.php?select2=ALLBUT0999&chk_date=104/01/05
ºô­¶·|Åã¥Ü"¬dµL¸ê®Æ:104¦~01¤ë05¤é"
½Ð°Ý§Ú¬O¨º¸Ì¥Î¿ù¤F.

TOP

TOP

¦^´_ 6# josephtsai
±z¦n,
       ÁÂÁ±zªº¦^µª,½Ð°Ý±z¬O«ç»ò§ä¨ì³o­Ó³sµ²¦r¦êªº,±zªº³sµ²¥u¥i¥H¬Ý"¤j½L²Î­p¸ê®Æ",§Ú¬O·Q­n¬Ý¨ì"¨C¤é¦¬½L¦æ±¡(¥þ³¡(¤£§tÅvÃÒ¡B¤ûºµÃÒ))",­n¦p¦ó­×§ï?

TOP

¦^´_ 7# imingho
ª½±µµ¹°Ñ¼Æ§ì¤£¨ì
¤£¯à¥Îgetªº¤èªk¡A­n§ï¥Îpostªº¤èªk¤U¸ü¸ê®Æ

TOP

¦^´_ 8# joey0415
ÁÂÁÂ.§Ú§ï¥Îpost´N¥i¥H¥¿±`Åã¥Ü¤F.

TOP

imingho±z¦n¡A¤£¦n·N«ä¡A¦]Åv­­¤£¨¬µLªk¤U¸üªþ¥ó¡A±z­nµ{¦¡½X°Ñ¦Ò¤@¤U¶Ü? «D±`·PÁ³á

TOP

        ÀR«ä¦Û¦b : §g¤l¥ß«í§Ó¡A¤p¤H«í¥ß§Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD