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

[µo°Ý] ¡¹½Ð±Ð¦U¦ì vba¾ã²z¼Æ¾Ú°ÝÃD¡A®Ú¾Ú±ø¥ó¡A¶}¯S©w·sÀÉ¡A¶KÀÉ¡AÀx¦s¡A¦A±ø¥ó§PÂ_ªº°ÝÃD

¦^´_ 9# yagami12th
2011_1¤ë«´¬ùªº¶}­Ü¨ìµ²ºâ¬O±q2010/12/16¨ì2011/1/19¡A¨Ã¤£¬O­è¦nªº1/1¨ì1/31¡A
§A¥i¥H±N©Ò¦³ªº ´Á³f¥æ©ö ¸ê®Æ¬Ò¸m©ó¤@¸ê®Æ®w
°j°é±ø¥ó 1.¨î­q¶}­Ü¤é´Á~µ²ºâ¤é´Á, 2.¼i¬ù»ù, 3.¶R½æÅv,  ¿z¿ï¸ê®Æ

TOP

¥»©«³Ì«á¥Ñ yagami12th ©ó 2012-1-7 00:21 ½s¿è

§Ú¦A¬ã¨s¬Ý¬Ý¡AÁÂÁÂGBKEE¤j¡A§Ú­qªº·s®Ñ¡Aexcel+vba+¸ê®Æ®w+À³¥Îªº¾ã¦X¹ê°È³o¥»®Ñ²×©ó¨Ó¤F¡A­è­è¬Ý¨ì¸Ì­±¦³¤£¤Ö¦n¨Ò¤l¡AÀ³¸Ó¥i¥H¶i¨B¤£¤Ö¡A¦pªG§â½m²ß®Ñ¤W°µªº¨Ò¤l©ñ¨ì½×¾Â¤W·|¤£·|¦³ªk«ß°ÝÃD¡C

­n¾Ç²ßªº­«ÂI¡G

¦r¨å¤¸¥ó<<<³o­Ó¦n¹³¦³§ä¹ï©¤½×¾Â¡D¡D
AutoFilter<<<³o­Ó§Ú­qªº·s®Ñ¸Ì­±¦³¤@¨Ç»¡©ú
array
for each

TOP

¦^´_ 7# yagami12th

³Ìªñ¥¿¦n¸òY¤j¤@¼Ë¦b°µªº¿ï¾ÜÅv¾ú¥v¸ê®Æ¾ã²z....¥Ñ©ó¨S¦³¾Ç¹LVBA, ­ì¥»·Q§Q¥Î¨ç¼Æ¨Ó¾ã²z¹LÂo¸ê®Æ...

ÁÙ¥¿¦b´M§ä¬ÛÃö¨Ò¤l»P»{ÃѬÛÃöªº¨ç¼Æ...
¬Ý¨Ó­n¦Ò¼{ª½±µ¾ÇVBA¤F...

­ì©l¸ê®Æ¸òY¤j¤@¼Ë, ¥]§t ¥æ©ö¤é´Á¡B¥æ³Î¤ë¥÷¡B¼i¬ù»ù¡B¶R½æÅv 4­ÓÅܼÆ
§Æ±æ¯à°÷¾ã²z¥X¥H¤U´X¶µ¼Æ¾Ú:

1. ¨C¤éT«¬³ø»ùªí, (¿é¤J ¥æ©ö¤é´Á¡B¥æ³Î¤ë¥÷), Åã¥Ü¦p¤U³sµ²
http://www.linyuda.url.tw/txo/Txo2012-2-17.htm

2. ¨C­Ó¤ë¥÷¨C­Ó¼i¬ù»ùªºput/call ªº»ù®æ¡]¿é¤J ¥æ³Î¤ë¥÷¡B¼i¬ù»ù)

3. put/call ³Ì¤jOI ¤ÀªR
    ¡]Y¤j¦b¥t¤@½g¤å³¹¦³´£¥X°Q½×¤F¡^

¥Ñ©ó®É¶¡¦³­­¡A¥u¯à¤@¨B¤@¨B¾Ç...
¦³°ÝÃD¦A¨Ó½Ð±Ð Y ¤j....
·PÁ¡I¡I

TOP

        ÀR«ä¦Û¦b : ­n§åµû§O¤H®É¡A¥ý·Q·Q¦Û¤v¬O§_§¹¬üµL¯Ê¡C
ªð¦^¦Cªí ¤W¤@¥DÃD