µ{¦¡½X¦p¦ó¼g¥H¬ö¿ýEXCELªºDDE¼Æ¾Ú¨C¬íÄÁ¬ö¿ý)(¤w¸Ñ¨M)
- ©«¤l
- 86
- ¥DÃD
- 30
- ºëµØ
- 0
- ¿n¤À
- 140
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- XP
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-2-19
- ³Ì«áµn¿ý
- 2020-8-26
|
µ{¦¡½X¦p¦ó¼g¥H¬ö¿ýEXCELªºDDE¼Æ¾Ú¨C¬íÄÁ¬ö¿ý)(¤w¸Ñ¨M)
¥»©«³Ì«á¥Ñ jiuhtsair ©ó 2011-8-23 17:55 ½s¿è
¦U¦ì¤j¤j¦n¡G
¹ï©óVBA§Ú¬O·s¤â¡I
¦bºô¸ô¤W¬Ý¨ì³\¦h°ª¤â¼g¥X¦³ÃöDDE¬ö¿ýªº°ÝÃD¡A¦ý¤j¦h¬O¬ö¿ý¤@¤ÀÄÁ©Î¬O¤@¤ÀÄÁ¥H¤Wªº®É¶¡¡C´¿¹Á¸Õ±N¨ä§ó§ï¦¨¨C¬í¬ö¿ý¤@¦¸¡A«oÁ`¬O¤£±o¨äªù¦Ó¤J...
§Ú·Qn§âDDE¶Çµ¹EXCELªº¸ê®Æ(®É¶¡¡B¶}½L»ù¡B³Ì°ª»ù¡B³Ì§C»ù¡B¦¬½L»ù¡B³æ¶q¡B¦¨¥æ¶q)¡A¨Ì·Ó®É¶¡¨C¤@¬í¬ö¿ý¤@¦¸(©ñ¦b¥t¤@Ó¤u§@ªí¤¤)¡A¤£ª¾¹D¯à§_½Ð¤j¤j̨ó§U¡HÁÂÁ¡I
¥t¥~¡A¯à§_¤¶²Ð´X¥»VBA¤Jªù®Ñ¡A¦b§{¶¡¦³³\¦h®Ñ¡A¦ý¬Ýªº²´ªá¼º¶Ã¡A¤]Àµ½Ð¤j¤j̤w¹L¨Ó¤H¸gÅ礶²Ð´X¥»¦n®Ñ...ÁÂÁ¡I |
|
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X
|
|
|
|
|
- ©«¤l
- 86
- ¥DÃD
- 30
- ºëµØ
- 0
- ¿n¤À
- 140
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- XP
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-2-19
- ³Ì«áµn¿ý
- 2020-8-26
|
·PÁ¤j¤j¶}¥Ü¡C´¿¬ã¨s¤F¤j¤j¦^µªEXCELªºDDE¼Æ¾Ú¨C¤ÀÄÁ¬ö¿ýªº¤å¡A¥i±¤¨S§¹¥þ§ËÀ´...³oµ{¦¡¤w¸g·Ð´o¤@¬P´Á¤F¡A·PÁ¤j¤j¸Ñ°£§x´b¡CÁÂÁ¡I |
|
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X
|
|
|
|
|
- ©«¤l
- 27
- ¥DÃD
- 7
- ºëµØ
- 0
- ¿n¤À
- 69
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office 2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-4-19
- ³Ì«áµn¿ý
- 2012-6-26
|
§Ú¤]ÁÙ¬O·s¤â¡AÁöµMµ{¦¡ªº³¡¤ÀÁÙ¨S¿ìªkµ¹¤©À°§U¡A¤£¹L®ÑÄyªº¸Ü¥i¥H±ÀÂ˵¹§A
Excel VBA 2007 µ{¦¡³]p¥þ¹Ï¸Ñ ¹q¸£¤H¤å¤Æ ¥Xª©
§@ªÌ:¤C±ø¹F¥° ´çÃä°· ...µ¥¤Hª`
³o¥»»¡ªºÁÙÆZ¸Ô²Óªº¡A§Ú¥Ø«e¦Û¾Ç¤T¶g¡AÁöµM¨S¿ìªk¹³ª©¥D¥L̵{¦¡¥´±o«Üºë²¡A
n¤°»ò¦³¤°»ò¡A¦ý¬O¤w¸g¥i¥H¦Û¤v°µ¥X¤@¨Ç°ò¥»¥\¯à¡A
¤W¤@¨B¡B¤U¤@¨B¡B¦b¤¶±¤¤¿é¤J¸ê®Æ¨Ã°e¦^..µ¥¥\¯à
¥B®Ñ¤¤ªº½d¨Ò¥i¥H¤U¸ü
ºô§}:http://www.pcuser.com.tw/download/2AC710/samples.zip
±ÀÂ˵¹§A~~ |
|
|
|
|
|
|
- ©«¤l
- 86
- ¥DÃD
- 30
- ºëµØ
- 0
- ¿n¤À
- 140
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- XP
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-2-19
- ³Ì«áµn¿ý
- 2020-8-26
|
ÁÂÁ¤À¨É¡I§Ú¤]§ä¨ìÓ¤£¿ùªº±Ð¾Çºô¯¸
http://210.240.125.13/phcno1/index.htm ½Ð°Ñ¦Ò¡I |
|
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X
|
|
|
|
|
- ©«¤l
- 86
- ¥DÃD
- 30
- ºëµØ
- 0
- ¿n¤À
- 140
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- XP
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-2-19
- ³Ì«áµn¿ý
- 2020-8-26
|
§Ú±Nµ{¦¡½X¶K¤W«á¡A¥¦§i¶D§Ú"°õ¦æ¶¥¬q¿ù»~424¡A¦¹³B»Ýnª«¥ó"
¦ý¨S¦³¬Ý¨ì¥L©Ò«üªº¿ù»~°Ï°ì¦bþ¸Ì¡A½Ð°Ý³on¦p¦ó§ï©O?
¥t¥~¡ADDE¶Ç¦^ªº®É¶¡¬OÈ=(X¤p®É*3600+Y¤ÀÄÁ*60)/86400¡A¤£ª¾¹D³o¼Ë§â³]A=Time·|¤£·|¦³°ÝÃD¡A§Ú¬O§_n¥ý±N(X¤p®É*3600+Y¤ÀÄÁ*60)/86400Âà¤Æ¦¨ "X¤p®É¡GY¤ÀÄÁ:Z¬íÄÁ"ªº«¬ºA©O?
ÁÂÁ¡I |
|
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X
|
|
|
|
|
- ©«¤l
- 86
- ¥DÃD
- 30
- ºëµØ
- 0
- ¿n¤À
- 140
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- XP
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-2-19
- ³Ì«áµn¿ý
- 2020-8-26
|
©êºp¡I©È³¯zªº¤£²M·¡¡A§Ú§â§ÚªºDDEÀɮפ]¶Ç¤W¨Ó¡CÀµ½Ðºô¤W¤j¤j¸Ñ´b¡IÁÂÁ¡I
·Qn°µªº¥\¯à´N¬O§âsheet1ªº¤º®e¨C¬íÄÁ(a2Àx¦s®æ¤º®eÅܤƮɰʧ@)¦s¤JSheet2¤¤¡I§Æ±æ¯à°÷¬ö¿ý¤@¾ã¤Ñ¥H«K¤ÀªR°Ñ¦Ò¡CÁÂÁ¡I
TFXexcel_DDE.zip (7.89 KB)
|
|
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X
|
|
|
|
|
- ©«¤l
- 5923
- ¥DÃD
- 13
- ºëµØ
- 1
- ¿n¤À
- 5986
- ÂI¦W
- 0
- §@·~¨t²Î
- win10
- ³nÅ骩¥»
- Office 2010
- ¾\ŪÅv
- 150
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥xÆW°ò¶©
- µù¥U®É¶¡
- 2010-5-1
- ³Ì«áµn¿ý
- 2022-1-23
|
¦^´_ 7# jiuhtsair
¸Õ¸Õ¬Ý- Sub Ex()
- Dim A As Single
- A = 0.361111 '®É¶¡ ¤W¤È 08:40:00
- j = 2
- Do
- DoEvents
- 'If Sheets(2).Cells(j, 2) > A Then
- ' A = Sheets(2).Cells(j, 2)
- If Sheets(1).Cells(2, 1) > A Then 'SHEETS(1)ªºA2¤j©ó ®É¶¡
- A = Sheets(1).Cells(2, 1) '§ó§ï®É¶¡¬°SHEETS(1)ªºA2
- ' -- ªþÀÉ Sheets(1).Cells(3, 5)...... ¬°ªÅ¥Õ --
- 'Sheets(2).Cells(j, 2) = Sheets(1).Cells(3, 5)
- 'Sheets(2).Cells(j, 3) = Sheets(1).Cells(3, 6)
- 'Sheets(2).Cells(j, 4) = Sheets(1).Cells(3, 7)
- 'Sheets(2).Cells(j, 5) = Sheets(1).Cells(3, 8)
- 'Sheets(2).Cells(j, 6) = Sheets(1).Cells(3, 9)
- 'Sheets(2).Cells(j, 7) = Sheets(1).Cells(3, 10)
- Sheets(2).Cells(j, 2).Resize(1, 6) = Sheets(1).Cells(2, 5).Resize(1, 6).Value
- O = 0
- H = -99999
- l = 99999
- cumVol = V
- j = j + 1
- End If
- Loop
- End Sub
½Æ»s¥N½X |
|
|
|
|
|
|
- ©«¤l
- 86
- ¥DÃD
- 30
- ºëµØ
- 0
- ¿n¤À
- 140
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- XP
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-2-19
- ³Ì«áµn¿ý
- 2020-8-26
|
·PÁ¤j¤j¸Ñ´b¡I
µ{¦¡½X19¦æ¨ì22¦æ¡A·íªì¬O¬Ý¨ä¥Lµ{¦¡¥é³yªº¡A¦pªG§Ú¨S¦³¥Î¨ì¥¦ªº¹Bºâ¦¡(¥Lì¥ý¬O§Q¥Î²Ä¤@Ó»ù¿ú¬°¶}½L»ùO¡A²Ä¤GÓ»ù¿ú¦pªG°ª©ó²Ä¤@Ó¡A¨º³Ì°ª»ù´N¬O²Ä¤GÓ¡A¦pªG²Ä¤GÓ»ù¿ú§C©ó²Ä¤@Ó¡A¨º³Ì§C»ù´N¬O²Ä¤GÓ...)§Ú¬O§_¥i¥H§â¥¦¥h°£¡H
©ú¤Ñ¶}½L«á¸Õ¸Õ¡I·PÁ¡I |
|
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X
|
|
|
|
|
- ©«¤l
- 86
- ¥DÃD
- 30
- ºëµØ
- 0
- ¿n¤À
- 140
- ÂI¦W
- 0
- §@·~¨t²Î
- windows
- ³nÅ骩¥»
- XP
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2011-2-19
- ³Ì«áµn¿ý
- 2020-8-26
|
£~£~..·PÁ¡IOK¤F¡I
§Ú¥Î¤â°Ê¤è¦¡§ïÅܮɶ¡...°õ¦æµ{¦¡«á¤@¦p©ÒÄ@¡I
ÁÂÁ¤j¤j¸Ñ´b¡C·PÁ¡I |
|
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X
|
|
|
|
|