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

[µo°Ý] ¦³ÃöÀɮפj¤p°ÝÃD

[µo°Ý] ¦³ÃöÀɮפj¤p°ÝÃD

ªñ¨Ó§Ú©ó¤@­Ó Excel Àɮפº¥[¤J VBA  µ{¦¡,
¨C©ó§ó§ï³¡¥÷µ{¦¡½X/¤º®e«á¦sÀÉ,
´N·|µo²{¦³¤@­Ó©_©Çªº²{¶H,
­ì Excel Àɪº®e¶qÀ³¬ù¬° 300 - 400 KB.
¦ý¦³®É­Ô·|©ó¸ÓÀɮקó§ï¤Ö³¡¥÷¤º®e.
(¨Ò¦p©ó Sheet1 ªº A1 ¥Ñ  a §ï¬° b)
Àɮתº¤j¤p´N·|¥Ñ 300 ¦h KB ¸õ¼W¨ì 600 - 700KB.
§Y¨Ï°¨¤W¶}¦^¸ÓÀɮקâ b §ï¦^ a ¤]¬O¤@¼Ë.
¦ý¦³®É­Ô©ó¨Ï¥Î¤@¬q®É¶¡«á¦A¦sÀÉ¥¦¤S·|¦A¦¸Åܦ^¤p®e¶q.

¤j®a¦³¨S¦³¹J¹LÃþ¦üªº°ÝÃD?  °ÝÃD¥X¦b¨º¸Ì?
(·|§_»P¼È¦sÀɦ³Ãö ?)

¦^´_ 1# jimmyhk


    §Ú¤]¦³µo²{³o¼Ëªº°ÝÃD¡A¦ý¬O¤]¨S¦³§ä¨ì¯u¥¿ªº­ì¦].....
    ¥u¬O©¿¤j©¿¤pªºµ{«×¨S¦³ 300K-->600K³o»ò¼@¯P...
    ¤j·§³£¦b 100K¥ª¥k....

TOP

¦^´_ 2# jsleee

§Úªº®t¶Z«Ü¤j~~~
¦]¬°§Ú¬O¥Î TrueCrypt «Ø¥ß¤F¤@­Ó«Ü¤Öªº¦a¤è (1024KB) ¥Î¨Ó©ñ³o­Ó¤pÀÉ®×,
¦pªG¥¦¤@ª½¬O 300-400 KB ©ó¨Ï¥Î¤W´N¨S¦³°ÝÃD,
¦ý¤@·í¥¦"Åܤj"ªº®É­Ô´N·|¥X²{ºÏºÐ®e¶q¤£¨¬,
µ²ªG´N·í Excel ¤F...  :'(

TOP

¦^´_ 1# jimmyhk

¬O§_¨S¦³¤Hª¾¹D/¹J¹L§Ú³o­Ó°ÝÃD.
¦]¬°§Ú·|§âÀɮשñ¨ì 1.44MB ªº Floppy ¨Ï¥Î.  (¤£­n°ÝÃD¬°¤°»òÁÙ­n¥Î Floppy...)  :'(
©Ò¥H¹ï§Ú¼vÅT«Ü¤j

TOP

©óºô¤W§ä¨ì¤@­Ó¤èªk,
Áö¤£©ú¥Õ­ì¦]¬°¦ó,
¦ý¥¦°¨¤W´Nµ¹§Úªº xls ´î¤F¤@¥b.

¤j®a©Î¥i°Ñ¦Ò¦³Ãö¤èªk.

¦pªGEXCELÀɮפºªº¸ê®Æ¨Ã¤£¦h,¦ý¸ÓÀɮפj¤p«o«Ü¤j,³y¦¨¨Ï¥Î¤W°ÝÃD

¦pªGEXCELÀɮפºªº¸ê®Æ¨Ã¤£¦h,¦ý¸ÓÀɮפj¤p«o«Ü¤j,¾É­P¶}±Ò¡B½s¿è¡B¦sÀÉ¡B§R°£µ¥µ¥°Ê§@³£Åܱo«ÜºC,¨Ï¥Î°_¨Ó«Ü¦Y¤O,­ì¦]¬°¦ó?
Ans:

¥i¯à¬OEXCEL¤¤¦³¹L¦h¤£»Ý­nªº"ª«¥ó",¥i³z¹L¤U¦C¤èªk§Ö³t§R°£¤£¬O¸ÓÀɮפ¤©Ò»Ý­nªº"ª«¥ó"
1.¥ý±NÀÉ®×¥t¦s·sÀÉ¡A¥H¨¾¸U¤@
2.ÂI¿ï"½s¿è"¥\¯àªí,°õ¦æ"¨ì"ªº¥\¯à (©Î¦P®É«öCTRL+GÁä),²£¥Í"¨ì"¯Á¤Þ¼ÐÅÒ
3."¨ì"¯Á¤Þ¼ÐÅÒ¤U,ÂI¿ï[¯S®í]Áä,©ó"¯S®í¥Ø¼Ð"¤U,±N"ª«¥ó"¿ï¶µ¤Ä¿ï«ö"½T©w",
¦A«ö"DEL"Áä,´N·|§âª«¥ó§R°£

­Y´¿´¡¤Jª«¥ó,§R°£¦C®É¥¼¨Æ¥ý§â¸Óª«¥ó§R±¼,¦Ó¬Oª½±µ§R°£¦C,¦¹ª«¥óÀÉ´N·|·tÂæb¦CÁ_»Ø¤¤,­Y­è¦ncopy¦¹¦C,´N·|³s±aª«¥óÀɤ@°_½Æ»s,¥H­PÀÉ®×·Uºu·U¤j,³o´N¬O°ÝÃDªº¥D­n­ì¦],©Ò¥H§R°£¤£»Ý­nªº"ª«¥ó",´N¥i¥H«ì´_¥¿±`


http://my-db.blogspot.com/2009/07/excel_30.html

TOP

¬Ý¤@¤U««ª½±²¶b
¦³®É©¹¤U««ª½±²°Ê®É
·|±²¥X«Ü¦hªÅ¥Õ¦C(¥¿±`¬O±²¨ì¸ê®Æªº³Ì«á¤@¦C)
§âªÅ¥Õ¦C¾ã¦C§R°£«á¦A¦sÀÉ

TOP

¬Ý¤@¤U««ª½±²¶b
¦³®É©¹¤U««ª½±²°Ê®É
·|±²¥X«Ü¦hªÅ¥Õ¦C(¥¿±`¬O±²¨ì¸ê®Æªº³Ì«á¤@¦C)
§âªÅ¥Õ¦C¾ã¦C§R°£«á¦A ...
register313 µoªí©ó 2011-11-16 12:54



³o­Ó¤èªk¦³¸Õ¹L, ¦ý¤£¬O¼vÅT³Ì¤jªº¦a¤è.

TOP

°ò¥»¤WÁÙ¬O­nª¾¹D¦Û¤vªºÀɮתΤjªº­ì¦]¹ï¯g¤UÃÄ
§O¤Hªº¸gÅ礣¨£±o¾A¥Î¦b¦Û¤vªºÀɮפW¡C

TOP

§Úµo²{§Ú2007ª©¥»ÀÉ®×(§tvba code)­Y¬O§ï¥Î2002ª©¥»ª½±µ¦A¦s¤@¦¸¡A¥i¥H±q4MBª½±µ½G¨­¦¨1MB¡A¥\¯à¤@¼Ë³£¤£¤Ö¡K¥u¬O¤£ª¾¹D­ì¦]¬°¦ó...¦³¤Hª¾¹D¶Ü?

TOP

§Ú¦³¹J¹L, Àɮ׸̤Ӧhªºª«¥ó,±N­ì¥»ªº8MBÅܦ¨20MB.
­ì¥»¤£ª¾¹D¬Oª«¥óªºÃö«Y,ª½±µ¶}¤@­Ó·sªºÀÉ®×,½Æ»sraw data, (­n¿ï¨ú¯u¥¿dataªº½d³ò¦A½Æ»s).
¦AºCºC¥[¤W©Ò»Ýªº¨ç¼Æ,µ{¦¡,®æ¦¡....¤@¨B¤@¨B¬ÝÀɮפj¤pªºÅܤÆ. ³Ì«á¤~µo²{¬O¤Ó¦hªºª«¥óÅýÀÉ®×Åܱo¦p¦¹¤j.
fangac

TOP

        ÀR«ä¦Û¦b : ¦³¤ß´N¦³ºÖ¡A¦³Ä@´N¦³¤O¡A¦Û³yºÖ¥Ð¡A¦Û±oºÖ½t¡C
ªð¦^¦Cªí ¤W¤@¥DÃD