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

EXcel VBA °õ¦æÀô¹Ò »P ³t«×

EXcel VBA °õ¦æÀô¹Ò »P ³t«×



¥Ø«eÁÙ¬O¨Ï¥Î XP  & Excel 2010 ªºÀô¹Ò.

½Ð°Ý¡A­Y§@·~¨t²Î¨Ï¥Î¡@Win 7 64bits & Excel 2010 64 bits ª©¥»¡A
¦b¡@Excel VBA ªºÂ¦³µ{¦¡½X¡A¬O§_·|¦] ´£¤É¦Ü 64 bits ªºÀô¹Ò¤U¡A¦ÓÅý VBA µ{¦¡ªº°õ¦æ³t«×¡A
¯à¦³ 20% ¥H¤Wªº´£¤É¡H

´«ª©¥»³t«×·|ÅܧֶÜ??

TOP

·PÁ¼ӤW°ª¤âªº¦^µª¡A
¤p§Ì°µ­Ó¤pµ²¡G
¢°¡DVBA ¬O¨Ìªþ ¦b Office ¨t¦C¥­¥x¡A¤~¯à°õ¦æ
¢±¡DVBA ¤£¯à¹³±M·~ ...
alumi µoªí©ó 2012-12-13 19:25


°ò¥»¤W¡AVBA²¦³º¥u¬O¤@­ÓªþÄݪº®M¥ó¡A¨Ã¤£¬O¹³ ¨ä¥Lµ{¦¡½sĶ³nÅé¥iª½±µ½sĶ¦¨°õ¦æÀɮסC
    ³o¤]ª¾©Ò¥H²{¤µ«Ü¦h¤H³£¥u¬O§âEXCEL ·í¦¨¬O²©öªº²Î­p¤ÀªR³nÅé ¤@¼Ë·N«ä¡C

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

·PÁ¼ӤW°ª¤âªº¦^µª¡A
¤p§Ì°µ­Ó¤pµ²¡G
¢°¡DVBA ¬O¨Ìªþ ¦b Office ¨t¦C¥­¥x¡A¤~¯à°õ¦æ
¢±¡DVBA ¤£¯à¹³±M·~ªºµ{¦¡»y¨¥¶}µoÀô¹Ò¡A°£¤F²Ó¸`ªº½Õ®Õ¡A§óµLªk½sĶ¦¨°õ¦æÀÉ¡D
¢²¡D´Nºâ¬O¨Ï¥ÎVSTO ¡A¤]¬O¤@¼Ë¡D
¢³¡DVBA »P Office ¤¸¥ó¡A¦³¾ú¥vªº¥]µö¡D

TOP

¥»©«³Ì«á¥Ñ alumi ©ó 2012-12-13 00:24 ½s¿è




¥i¯à§Úªº°ÝÃD¡A¨S¦³»¡©ú²M·¡¡D
µ{¦¡½X¨S¦³¥ô¦ó°ÝÃD¡A¤v³Ì¨Î¤Æ¡D
¬Û¦Pªº¡@VBA Code ,
¦b¡@Win7 64bit & Excel 2010 64 bit ª© ¬O§_¯à°÷¤ñ¡@Win7 32bit & Excel 2010 32 bit ª© ªºÀô¹Ò¤U¡A
µ{¦¡°õ¦æ³t«×¬O§_·|¦³ 20% ¥H¤Wªº´£¤É¡H
¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð¡Ð



TOP

¦^´_ 5# stillfish00

¬O¥H Vba Code ¥´­Ó¤ñ¤è¦Ó¤w

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

4#
»¡ªº¤ñ¸û¹³¬O32-bit©M64-bit CPU³B²z³t«×ªº¤ñ¸û , ³o­Ó²z½×¤W¨â­¿§ÚÁÙ¤ñ¸û¯à±µ¨ü.
¦ý¬O¦P¼ËªºVBA code ©ñ¦b32¦ì¤¸§@·~¨t²Î©M64¦ì¤¸§@·~¨t²Î , §¹¥þ¬O¨â­Ó·§©À

TOP

¥»©«³Ì«á¥Ñ mark15jill ©ó 2012-12-10 11:43 ½s¿è

¦^´_ 1# alumi


1.­Y³nÅ骩¥»¡B­ìµ{¦¡ »P §@·~¨t²ÎÀô¹Ò(¦©°£ 32bit »P 64bit ªº¼vÅT )¬Û¦P ¡A²z½×¤W¡A°õ¦æ³t«×·|§Ö¤@­¿¡C<½Ð¬Ý°Ñ¦Ò¸ê®Æ¤@>
2.­Y­ìµ{¦¡¤§¹B¦æ¤è¦¡½ÆÂø©Ê°ª¥B¤£¨}¡A¨º¤£ºÞ¬O 32 bit ©Î 64 bit ¦ü¥GµLªk¥h°µ¦³®Äªº®Ä²v¼W´T¡C´«¥y¸Ü»¡¡A­Y­ìµ{¦¡³]­p¤£¨}©Î¤w³´¤JµLºÉ°j°é¡A¨º«ç´£¤ÉÁÙ¬O¤@¼Ë¨S¥Î¡C


<°Ñ¦Ò¸ê®Æ¤@¡B[Â^¨ú basuya noacaciana ¤j¤j ¤§ Windows ¤¤ 32bit(x86) ©M 64bit(x64) ªº¸ÑÄÀ ¤@¤å]
[°Ñ¦Òºô§}¡G http://basuya.blogspot.tw/2012/0 ... itx86-64bitx64.html

Windows ¤¤ 32bit(x86) ©M 64bit(x64) ªº¸ÑÄÀ

3¡B¹Bºâ³t«×¤£¦P¡C
64 bit CPU GPRs(General-Purpose Registers¡A³q¥Î¼È¦s¾¹)ªº¸ê®Æ¼e«×¬°64 bit¡A64 bit «ü¥O¶°¥i¥H¹B¦æ 64 bit ¸ê®Æ«ü¥O¡A¤]´N¬O»¡³B²z¾¹¤@¦¸¥i´£¨ú 64 bit ¸ê®Æ(¥u­n¨â­Ó«ü¥O¡A¤@¦¸´£¨ú8­Ó byte ªº ¸ê®Æ)¡A¤ñ32bit(»Ý­n¥|­Ó«ü¥O,¤@¦¸´£¨ú4­Óbyteªº¸ê®Æ)´£°ª¤F¤@­¿¡A²z½×¤W©Ê¯à·|¬ÛÀ³´£¤É1­¿¡C

4¡B´M§}¯à¤O¤£¦P¡C64bit³B²z¾¹ªºÀu¶ÕÁÙÅé²{¦b¨t²Î¹ï°O¾ÐÅ骺±±¨î¤W¡C¥Ñ©ó¦ì§}¨Ï¥Îªº¬O¯S®íªº¾ã¼Æ¡A¦]¦¹¤@­ÓALU¡]ºâ³NÅÞ¿è¹Bºâ¾¹¡^©M±H¦s¾¹¥i¥H³B²z§ó¤jªº¾ã¼Æ¡A¤]´N¬O§ó¤jªº¦ì§}¡C¤ñ¦p¡AWindows Vista x64 Edition¤ä«ù¦h¹F128 GBªº°O¾ÐÅé©M¦h¹F16 TBªºµêÀÀ°O¾ÐÅé¡A¦Ó32bitCPU©M¾Þ§@¨t²Î³Ì¤j°¦¥i¤ä«ù 4G°O¾ÐÅé¡C>

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

²z½×¤W¬O·|§Öªº, ¦ý¹ê»Ú¤W¦³¤H¸Õ¹L¤À§O¤£¤j.
¤ñ¸û¦³®Äªº¤èªk:
µw¥ó:¦h¥[¨Ç¤º¦s,
¥N½X:¬Ý¬Ý¦³¨S¦³§ïµ½ªºªÅ¶¡
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

¦^´_ 1# alumi
¯u¦³¨º»ò¯«©_¡H
§Úªº¹q¸£Àô¹Ò»P§A©Ò´y¯Àªº¹p¦P¡A
§Úªº¬OºXÄ¥ª©¥»*(64 bit)¡A ¨Ï¥Î¨ì
¥Ø«e¬°¤î ¦pªG¦³§Ö¨ì¶W¹L 10%¡A ¨º
´NªüÀ±ªû¦ò¤F¡I

TOP

        ÀR«ä¦Û¦b : ¤@­Ó¯Ê¤fªºªM¤l¡A¦pªG´«¤@­Ó¨¤«×¬Ý¥¦¡A¥¦¤´µM¬O¶êªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD