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

[µo°Ý] ¿é¤J¼Æ­È«á¡A¦p¦ó±Ò°Ê¦Û°Ê¤U©Ô¤@®æªº¾÷¨î?

¦p¦ó¦bexcelªí¤¤§e²{¨C¤é5¡B10¡B20©P¤ë§¡½u­È

¥»©«³Ì«á¥Ñ finally0130 ©ó 2015-7-21 17:35 ½s¿è

¦U¦ìª©¤Í­Ì¤j®a¦n¡Aªñ¤é¤p§Ì¶}©l¾Ç²ßVBA¡A·Q±N¤é¦¬½L»ùÂà´«¬°5¡B10¡B20©P¤ë§¡½u­È¡A¸ê®Æ¤U¸ü¤@¯ë§¡¥H¤é¦¬½L»ù¬°¥D¡A¨Ó·½¬°(¤W¥«Âd¶R¤¤¤ß¡Byahoo finance ¡Bgoogle finance¡B¹d¦ëºô)¡A¨ä¤¤¶È¦³yahoo finance¦³´£¨Ñ¨C©P§¡»ù¡A¦ý¹ê»Ú¤ñ¹ï«áµoı³¡¤À­È¦³»~¡A¤£¤©°Ñ¦Ò¡C

¦bexcel¹ê§@¤¤¡Aµo²{¤é¦¬½L»ùÂର©P¦¬½L»ù·|¦³¤G­Ó°ÝÃD
1.¨C©P¶}½L¤é¼Æ¤£¦P¡AExcel§ì¨ú¸ê®Æ­È·|¦³»~
2.©P§¡»ù­Y±Ä¾÷°Ê¾÷¨î¡A·N¨ý¨C¤Ñ¤­©P§¡»ù­È³£·|ÅÜ¡A¦ü¥G§Þ³NÃø«×«Ü°ª

³o¨â­Ó°ÝÃD§x´b¤F¤p§Ì¦n´X¤Ñ¤F¡A¹ê¦b¬Oµ±ºÉ¸£¥Ä¤]·Q¤£¥X¦p¦óÅýExcelÅÜÁo©úªº¤èªk¡A¤£ª¾¬O§_ª©¤W¦³°ª¤â¯à¸ÑµªºÃ´b¡A·P®¦¦A·P®¦¡C

TOP

¦^´_ 1# finally0130


    ¬°¦ó¤£ª½±µ¥Ñ¨÷°Ó´£¨Ñªº¬Ý½L³nÅé¶×¥XEXCEL´N¦n?
¡÷

TOP

·PÁ¤j¤j¤À¨É¡A³o¤èªk¤]´¿·Q¹L¡A¦ý¤£ª¾¦p¦ó¥H¦Û°Ê¤Æ¤è¦¡¤U¸ü2000Àɤ½¥qªº¤é©P¤ë§¡­È¡A¥B»Ý¨C©P¨C¤ë§ó·s¡A¬O§_¦³¦ó¯S§O§Þ¥©¤j¤j¥i¤À¨É¤§¡A·P¿E¤£ºÉ¡C

TOP

¦^´_ 2# united7878


    ¥i¥H½Ð±Ð¤@¤U±z³o¬Ý½L³nÅé¬O­þ¤@®a劵°Óªº³nÅé?»Ý­n¥I¶O¨Ï¥Î¶Ü?¦¹¥~§Ú¤]·Qª¾¹D¼Ó¥D°Ý±o¦³¬Æ»ò¤è¦¡¥i¥H¦Û°Ê¦a§â©Ò¦³ªÑÅPªº¶}°ª§C¦¬»P¦¨¸û¶qµ¥¬ÛÃö¸ê®Æµ¹¶Ç¨ìEXCEL¸Ì

TOP

¦^´_ 3# finally0130

¥þ¤W¥«Âd³æ¤@¤é¦Û°Ê§ó·s¬O¥i¦æ
(¥i¥H§Y®É§ó·s¦¨¥æ»ù©M¶g¡B¤ë¡B©u¡B¥b¦~¡B¤@¦~ªºªi°Ê¤ñ²v)

¦ý­n¥þ³¡¤é´ÁÀ³¤£¤Ó¥i¯à
§A¥ú¬Ý¤@ÀɭӪѪº¨C¤éSMA§¡»ù´N¦û¦í¤@¾ã­Ó¤u§@ªí
³oÁÙ¬O200®Úk´Î¦Ó¤w
§A¦pªG­n¥þ³¡1500¦h®a¤W¥«Âd±q±¾µP¨ì¤µ¤Ñªº¦U§¡»ù
¨º­n¶}´X­¶¤u§@ªí¤~¯àÂsÄý¡H

TOP

RE: ¦p¦ó¦bexcelªí¤¤§e²{¨C¤é5¡B10¡B20©P¤ë§¡½u­È

[ª©¥DºÞ²z¯d¨¥]
  • GBKEE(2015/7/23 06:56): ¨q¤@¤U,¤gªk·Ò¿û,¬Ý¦p¦ó§ï¶i

°ò¥»¤W¡A¤p§Ì¥Ø«e±Ä¨ú§ó·s¡i¨C¤é¦¬½L»ù¡j¡A¥Hlookup¨ç¼Æ§ì¥X¨C©P¨C¤ë¦¬½L»ù¡A¦ý¸ê®Æ¦³¤Q¦~¡A¶È¯à±a¥X¤@¦~¥¿½T­È¡A­Y±N¿ï¨ú½d³òÅܤj«h¼Æ­È¿ù»~¡A
¤èªk¦³ÂI¤gªk·Ò¿û¡A¦pªG¤j®a¦³§ó¦nªº¤èªk¡A¥i¥H¦@¦P¤À¨É°Q½×¡C¼Æ¾Ú¤Î¹Ï¤ù¦p¤U¡A¦A½Ð¦U¦ìÀ°¦£¤@¤UÅo!!
¤é©P¤ë§¡½u¸ê®Æ®w (Rev.4)-µo°Ý¥Î.rar (460.68 KB)

TOP

¦^´_  united7878


   ¥i¥H½Ð±Ð¤@¤U±z³o¬Ý½L³nÅé¬O­þ¤@®a劵°Óªº³nÅé?»Ý­n¥I¶O¨Ï¥Î¶Ü?¦¹¥~§Ú¤]·Q ...
daniel5168 µoªí©ó 2015-7-23 00:42


¤@¯ë¨÷°Ó´£¨Ñªº¬Ý½L³nÅé³£¬O§K¶Oªº§a
§Ú¥Îªº´I¨¹e-01¡A³Ì§C¨Ï¥Î­­¨î±ø¥ó¬O¡G1.¶°«O®w¦s¤º¦³ªÑ²¼¡B2.¥b¦~¤º»Ý¦³¥æ©ö

¬Ý½L³nÅ骺­ÓªÑ¶×¥X¥\¯à´N¦³±z·Q­nªº¸ê®Æ§ó·s(§Y®É)

TOP

[µo°Ý] ¿é¤J¼Æ­È«á¡A¦p¦ó±Ò°Ê¦Û°Ê¤U©Ô¤@®æªº¾÷¨î?

¥»©«³Ì«á¥Ñ finally0130 ©ó 2015-7-23 20:09 ½s¿è

¤j®a±ß¦w¡A½Ð°Ý¦p¦óÅý¤â°Ê¤U©Ô¶ñº¡­pºâ¡AÂàÅܦ¨³æ®æ¦Û°Ê¡A¦p¹Ï¤ù©Ò­z
­º¥ý¡A¾Þ§@¹Lµ{¤¤¶ñ¤J¤é´Á«á¡A¥i¦Û°Ê±a¥X¥ª¤è¤ë©P¨ç¼Æ¡AµM¦Ó¡A¿é¤J»ù®æ®É¡AµLªk¦Û°Ê¦V¤U±a¥X¤­¤é§¡½u­È¡C

½Ð°Ý¬O§_¦³¿ìªk¦b¿é¤J¬Y¦C¼Æ­È¡AÅý¤â°Ê¤U©Ô­pºâªº¤è¦¡¡A§ï¬°¦Û°Ê¤U©Ô?

ºô§}¬°GIF¹ÏÀɥܷN¹Ï
http://recordit.co/mWppdl4hbe.gif


¦^´_ 1# finally0130


   ¥i¥H¥ÎWorksheet_Change¨Æ¥ó¡A¦p¤U¨Ò¡G
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 4 And Target.Row > 3 And Target <> "" Then '¦bDÄæ²Ä4¦C°_¡AÀx¦s®æ¤º®e¦³§ï¬°,¸ÓÀx¦s®æ¤£¬°ªÅ¥Õ®É±Ò°Ê
    <<<¤½¦¡©Î­n°õ¦æªºµ{¦¡>>>
End If
End Sub

TOP

¥»©«³Ì«á¥Ñ joey0415 ©ó 2015-7-23 21:30 ½s¿è

¦^´_ 6# finally0130

ÃÒ¥æ©Ò¤U¸ü¤@¤ÀÄÁ

ÂàÀɤ@¤ÀÄÁ
¸ê®Æ©ñ¶i®Æ®w¦paccess  mysql  sqliteµ¥¡A¦A³z¹Lsql»yªk«Ü§Ö¤~¹ï

¬d¸ß§¹«á¦A©ñ¶i¸ê®Æ®w¨Ò¦p§Aªº¬Yma­Èµ¥

²Ä¤@¦¸¥ý§å¦¸¡A¨Ò¦p1000¤Ñµ¥¡A¤ñ¸û¤[¡A¥i¯à¤T­Ó¤p®É¡A¤§®É´N¬O¨C¤Ñ¤G¤ÀÄÁ
«D±`¦³®Ä²v

¥H«e§Ú¦b¬Yºô¯¸¤Wªºµo°Ý¡A§Æ±æ¦³À°§U¨ì
http://www.mobile01.com/topicdetail.php?f=514&t=3522285&p=1#45891769

TOP

        ÀR«ä¦Û¦b : ±o²z­nÄǤH¡A²zª½­n®ð©M¡C
ªð¦^¦Cªí ¤W¤@¥DÃD