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

VBA°O¾ÐÅ餣¨¬°ÝÃD

VBA°O¾ÐÅ餣¨¬°ÝÃD

¦U¦ì¤j¤j¦n
·í§Ú¦b°õ¦æVBA®É¡A¦³®É·|¸õ¥X"°O¾ÐÅ餣¨¬"ªº¿ù»~µøµ¡

¤p§Ì¦³¥hGoogle¤F¤@¤U­ì¦]»P¸Ñªk
(½Ð°Ñ¦Ò¤U¦Cºô§})
http://excel.22ace.com/2010/11/excel-memory-not-enough.html

¦ý¬O¤p§Ì¤~¾Ç²Ê²L¡A¹ï©ó¤å³¹¤º®e¸Ñ¨M¤è¦¡¦³¨Ç¤£À´:
------¥H¤U¤Þ¥Î¤å³¹¤º®e-----------
µo¥Íªº­ì¦]
¨C­Ó Microsoft Excel °õ¦æ­ÓÅé¶È­­©ó 64 ¦Ê¸U¦ì¤¸²Õ (MB) ªº°O¾ÐÅé (¤º³¡°ï¿nªÅ¶¡)¡C¨C­Ó°õ¦æ­ÓÅé¤]¨ü­­©ó 32,760 ¨Ó·½Àx¦s®æªº·í±z°õ¦æ´¼¼zªº¶ñ¤J§@·~¡C·í±z½Æ»s©Î¶ñº¡¤j°Ï¬qªº¤u§@ªí¡B ¤@©Î¦h­Ó³o¨Ç­­¨î¥i¯à·|¼vÅTµ²ªG¡C

¸Ñ¨M¤è¦¡
ÁY¤p½d³ò
¦pªG­n¸Ñ¨M¨Ó·½Àx¦s®æ­­¨î¡A½Ð¨Ì·Ó¤U¦C¨BÆJ°õ¦æ¡G
1. ¶ñº¡¥u¦³±z¥²¶·¶ñº¡ªº½d³ò³¡¤À¡C
2. ¿ï¨ú³Ì«á¤@¦C©Î¶ñº¡½d³òªº³Ì«á¨â­Ó¸ê®Æ¦C¡C
3. ­«½Æ¨BÆJ 2¡Aª½¨ì±z¶ñ¤J±z»Ý­n¶ñ¤Jªº¾ã­Ó½d³ò¡C

¦pªG­n¸Ñ¨M°O¾ÐÅé­­¨î¡A±zªº¤u§@¤À¦¨¸û¤pªº¬¡­¶Ã¯¡A¨Ã¦b­Ó§Oªº°õ¦æ­ÓÅ骺 Excel ¤¤¶}±Ò¥¦­Ì¡C

-----¤å³¹¤Þ¥Î§¹²¦------------
¤p§Ì¤£À´±o¦a¤è¦b©ó²Ä2ÂI:
""¿ï¨ú³Ì«á¤@¦C©Î¶ñº¡½d³òªº³Ì«á¨â­Ó¸ê®Æ¦C¡C""

½Ð°Ýª©¤W¦³¤j¤j¬Ý±oÀ´ªº¡A¥i¥H¨ó§U¤p§Ì²z¸Ñ¤º®eªº·N«ä¶Ü?

·P®¦

        ÀR«ä¦Û¦b : °µ¦n¨Æ¤£¯à¤Ö§Ú¤@¤H¡A°µÃa¨Æ¤£¯à¦h§Ú¤@¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD