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

[µo°Ý] dde¶×¤J¼Æ­È«á¶i¦æ½Æ»s°ÝÃD

[µo°Ý] dde¶×¤J¼Æ­È«á¶i¦æ½Æ»s°ÝÃD

[ª©¥DºÞ²z¯d¨¥]
  • Hsieh(2011-12-25 16:08): ÀɮפW¶Ç¨ÃµLµ¥¯Å­­¨î

§â91­Ódde¶×¤J¼Æ­È¥H«ö¶s°Ê§@½Æ»s¥X91x2(182)­Ó¼Æ­È¥X¨Ó®É¶¡»Ý­n9¬í¡A¦pHsiehª©¥D©Ò¨¥"¤£·|§a!"¡A·Qª¾¹D½Æ»s¤j¶q°ÊºA¼Æ­È©ó¥t¤@Àx¦s®æ¤º¬O§_¤@©w³o¼Ë¯Ó®É¡HÁÙ¬O»s§@¤è¦¡¤Î¤½¦¡¤W¿ù»~¡A¥Ñ©óÁÙ¥¼°÷Åv­­¤W¶Ç¤å¥ó¡A¥u¯à¥H¤å¦r±Ô­z¤è¦¡ªí¹F¡A½Ð½Ì!

¦^´_ 2# mustang


    DDE°T¸¹¤@¯ë³£¬O±q劵°Ó³nÅé¤W¥ÎEXCELÄæ¦ìÂ^¨ú¨Óªº¡A¥­®É¥H¥N½X§e²{³s³q®É·|¨Ì²{ªpÅã²{¥X¼Æ¾Ú¡A¦ý¦b·Ç½Tºë«×¤W®Ä¯à·¥®t!!!!
¦]¦P¨B¥h¼Ë¤£¦P劵°Ó®É·|µo¥ÍÅã¥Ü¼Æ¾Ú¦³¸¨®t¡A¤£ª¾³o¬O¤£¬O¥xÆW¤~¿W¦³²{¶H¡A¦b°ê¥~DDE¬O¦Ñ¨ó©w¦­³Q²^¨O¤£¥Î¤F!!

µL©`³o¤@¯ë°ê¤º´²¤á¯à¨ú±oªº°T¸¹°ß¤@¨Ì¾Ú¡A©Ò¥H¥u¯àµwµÛÀY¥Ö¨ú¨Ó¥Î¤F!

¥H±d©M¥þ¦hÁȬ°¨Ò¶}±Ò¬Ý½L³nÅé«á¦b¤W¤è§ä(»²§U¤u¨ãÄæA)«ö¥ªÁä·Æ°Ê¥h±Ò°ÊMS EXCEL²£¥ÍªÅ¥ÕÄæ¦ì«á¦A¥H·Æ¹«Â^¨ú³ø»ùÄæ¥h¶K¤W´N¯à²£¥ÍDDE½X!

PS:µ´¹ï¤£¥i¦Û¦æ¶}±ÒEXCEL°µÂ^¨ú³o¼ËµLªk¨ú¼Ë!!ÁÙ¦³¥þ¦hÁȱ`±`·|·í¾÷­n¤p¤ß

TOP

¦^´_ 6# Hsieh


    ©Ò¥H­Y±NDDE°T¸¹Âà¤J¸ê®Æ®w¦A¦^±Â¹Bºâ
³o¼Ë¬O§_·|Åý¨t²Î®Ä¯à¦³®Ä´£¤É©O?

TOP

¦¨¥\¤F¡AÁÂÁÂHsiehª©¥D©Mregister313ºô¤ÍÀ°¦£¡C

TOP

¦^´_ 9# ²Â¤p«Ä
  1. Sub «ö¶s0_Click()

  2. For i = 1 To 7
  3.     Cells(1, i * 4 - 2).Resize(26, 1) = Cells(1, i * 4).Resize(26, 1).Value
  4. Next i
  5.         
  6. End Sub
½Æ»s¥N½X

TOP

¦^´_ 9# ²Â¤p«Ä
  1. Sub «ö¶s0_Click()
  2. Application.Calculation = xlCalculationManual
  3.     For i = 1 To 26
  4.         Cells(i, "B").Value = Cells(i, "D").Value
  5.         Cells(i, "F").Value = Cells(i, "H").Value
  6.         Cells(i, "J").Value = Cells(i, "L").Value
  7.         Cells(i, "N").Value = Cells(i, "P").Value
  8.         Cells(i, "R").Value = Cells(i, "T").Value
  9.         Cells(i, "V").Value = Cells(i, "X").Value
  10.         Cells(i, "Z").Value = Cells(i, "AB").Value
  11.     Next i
  12. Application.Calculation = xlCalculationAutomatic
  13. End Sub
½Æ»s¥N½X
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 5# register313


    copy test.rar (17.85 KB)

½Ð°ª¤â­Ì¬Ý¬Ý¦³¤èªk§â½Æ»s®É¶¡´î¤p¶Ü¡HÁÂÁÂ

TOP

¦^´_ 7# ²Â¤p«Ä


   Ãö³¬­«ºâ¦A°õ¦æ½Æ»s
Application.Calculation = xlCalculationManual


½Æ»s§¹¦¨­«·s³]©w¦Û°Ê­«ºâ
Application.Calculation = xlCalculationAutomatic
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 6# Hsieh


©ú¦ÛHsiehª©¥D¸ÑÄÀ¨Ï¥Î¤j¶q°}¦C¤½¦¡·|·l¯Ó¹q¸£¸ê·½¾É­P¹B§@½wºC¡A§Ú¤]Àv¸Õ§â¤å¥ó®³¨ìªB¤Í®a¶]1155 i3/3M§Ö¨ú¹q¸£°µ¹êÅç¡A¥i§â½Æ»s®É¶¡­°¦Ü4¬í§¹¦¨¡A

²{·Q¦p§¹¥þ¤£¨Ï¥Î®æ¦¡¤Æ±ø¥ó¡A¥u¨Ï¥ÎÀx¦s®æ¤½¦¡¨Ó»s§@§Ú·Q°µ¨ìªº¥Î³~¡A¤½¦¡¤W¯à»s§@¶Ü¡H½Æ»s®É¶¡¤W¯àÁYµu¶Ü¡H

TOP

¦^´_ 4# ²Â¤p«Ä
ÀɮפW¶Ç­ì«h
¦b¬¡­¶Ã¯¤º¥ô¦ó®æ¦¡³]©w¡B¤½¦¡³£·|¼vÅT¹Bºâ³t«×
¤×¨ä¦b¥Î¤F¤j¶q°}¦C¤½¦¡®É(¨Ã«D¥u¦³¥ÎCTRL+SHIFT+ENTER¬°¿é¤J¤è¦¡)
VBA¤]¨Ã«D´N¤@©w¯à´£¤É³t«×
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¦Û¤v®`¦Û¤v¡A²ö¹L©ó¶ÃµoµÊ®ð¡C
ªð¦^¦Cªí ¤W¤@¥DÃD