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

[µo°Ý] 1¤ñ46

[µo°Ý] 1¤ñ46

¦Ñ¹ê»¡¡A§Ú¤£ª¾¹D³o­Ó°ÝÃD­n±q¦ó°Ý°_=.=
§Ú¼g¤F¤@¤ä¤p¤pªºÁ~¸êµ{¦¡¡A¥Î¤½¥qªº¹q¸£°õ¦æÁ~¸ê­pºâ­n23¤À¤~¯à¶]§¹µ{§Ç¡A
¥Ñ©ó¤½¥qªº¹q¸£(xp+2003)¬O¥h¦~¤~§ó·sªº¡A
¹q¸£ªºµ¥¯Å¦A«ç»ò®t¤]¤£·|¤ñ®a¸Ì¤C¡B¤K¦~¨S§ó·sªº¹q¸£(xp+2003)®t¤~¹ï¡A
¥i¬O¡A¥Î®a¸Ìªº¹q¸£°õ¦æµ{§Ç¥u­n¥b¤ÀÄÁ´N¯à§¹¦¨¡A
§Ú°Ý¹L¹q¸£¤½¥q¡A¥L»¡À³¸Ó¬O§Úªºµ{¦¡¦³°ÝÃD~~
«á¨Ó¡A§Ú¦b¸g²zªº¹q¸£(win7+office2010)´ú¸Õ¡A¤£¥Î¥b¤ÀÄÁ´N¯à¶]§¹µ{§Ç
·Q½Ð°Ý¦U¦ì°ª¤â¡A§Ú­n¦p¦ó§ä¥X°ÝÃDÂI¥X¦b­þ©O?
±Æ°£µwÅé°ÝÃD¡A¬O¤£¬O¦³Ãþ¦ü¡u¤£·íªº¤Þ¥Î¶µ¥Ø¡v¦Ó¾É­P1:46ªº³t«×¤ñ??

¥Îf8Áä³v¨B°õ¦æ
À³¸Ó«Ü®e©öµo²{°ÝÃD¥X¦b¤°»ò¦a¤è

TOP

¦boobird¤j¤j¤W¦A¥[¤p³\
¬Ý¬Ý³o¨Ç¦³¨S¦³¹B¥Î¤W
application.calculation = xlmanual
application.screenupdate=false
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

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

TOP

¦^´_ 2# oobird
ª©¥D~
¤£ª¾¹D¬O¤£¬O§Ú¤S¸Õª±¤F¤°»ò¥\¯à...
®a¸Ì¹q¸£ªºF8¦ü¥G³Q§Oªº¥\¯à©Ò¨ú¥N¡A
«öF8¿Ã¹õµe­±·|Åܦ¨¦Ç¶¥ª¬¡A¤¤¶¡Áô¬ù¦³¤@¹ï¤j¤p¾¦½ü¹Ï§Î¡A

¤£ª¾¹D¤½¥qªº¹q¸£·|¤£·|¤]¦³³oºØª¬ªp0.0
­è¸Õª±¤F¤@¤U³v¦æ°»¿ù¡A¥Î·Æ¹«ÂI......ÂIªº¦n¨¯­WXD
¬P´Á¤@¤W¯Z¡A¦A´ú¸Õ¤½¥qªº³v¦æ°»¿ù~~

TOP

¦^´_ 3# kimbal
¶â~
§Ú·|¥ýÃö³¬¨º´X¦æµ{§Ç¡A¥ýÆ[¹î¬Ý¬Ý¥¦ªº°õ¦æª¬ªp¬O¤£¬O©M®a¸Ìªº¹q¸£¤@¼Ë¡A
¦A¨Ó¸Õ¸Õ³v¦æ°»¿ù~

TOP

³o³¡¥÷§Ú·Q«Øij¤@¤U
¦b¨C­Ó¼Ò²Õ»PTHISWORKBOOK»PSheet ¤¤
µ{¦¡³Ì¤W¤è
³æ¿W¥[¤W³o­ÓOption Explicit
½T«O©w¸q
¦A°õ¦æµ{¦¡¬Ý¬Ý
----------------------------------------
¥H«e­n¶]¦¨¥»­pºâ¤W¸U¤ñ¡A¦h»sµ{¦¨¥»®t¤£¦h­n¥b¤p®É¡C
¦h´ú´X¥x¹q¸£¡A¬Ý¬Ý¡A¦pªG¬O¨S¦w¸Ë¡AÀ³¸Ó·|¦³¿ù»~°T®§¡A¦Ó¤£¬O20¤ÀÄÁ¶]¥X¨Ó

TOP

¦^´_ 6# HUNGCHILIN
§Ú¤w§âOption Explicit¥[¤J¡A¨Ã¥¼µo²{²§¼Ë¡A
§Ú·Q¡A¥i¯à¬O¤§«e¤£·íªº¤Þ¥Î¶µ¥Ø¡A
Åܶq¥¼Án©úªº³¡¥÷³£¤w³Q§Ú­×¥¿¹L¤F...
©ú¤Ñ¨ì¤½¥q¦A¸Õ¬Ý¬Ý¦³¤°»ò²§±`²{¶H~


ps.¤j®vªº¤jÀY¶K´«¤FXD

TOP

¤µ¤Ñ¨ì¤½¥q¡A°µ¤F¥H¤Uªº´ú¸Õ...
§Ú¥ý¥H¥[¤JOption Explicitªºµ{¦¡½X°õ¦æ¡A°£¤FºC¥H¥~¨ÃµL²§±`²{¶H¡C
¦A¨Ó´N¬O¡AÃö³¬Application.ScreenUpdating = FalseÆ[¹î¥¦ªº°õ¦æª¬ªp¡A
¥¦¥H10´X¬íªº³t«×¦b°µ¤Á´«.....¤H¨ÆºÞ²z.xls©M¥X¶ÔÁZ®Ä.xls
(®a¸Ìªº¹q¸£¬O¥H¥b¬íªº³t«×°µ¤Á´«)
«á¨Ó¡A§Ú°µ³v¦æ°»¿ù....«öµÛF8¤£©ñ~
«Ü©úÅ㪺µ{§Ç¥d¦b..¶}±ÒÀɮשMÃö³¬Àɮ׳o¨â¦æ(¦U¬ù10´X¬í)
Workbooks.Open Filename:="D:\¤H¨ÆºÞ²z\¥X¶ÔÁZ®Ä.xls
Windows("¥X¶ÔÁZ®Ä.xls").Close
½Ð°Ý¦U¦ì¤j¤j¡A¦b¤°»òª¬ªp¤U¡A·|¾É­P¶}±Ò¡BÃö³¬Àɮ׳t«×ÅܺC??

TOP

¦^´_ 8# solely

§A¦b¤½¥q¥H¥~ªº¹q¸£¹B§@¥¿±`¡A§Úı±o¸ò§Aªºµ{¦¡½XÀ³¸ÓÃö«Y¤£¤j
§A¥i¥H¬Ý¬Ý¤½¥q¹q¸£°O¾ÐÅé¤j¤pÁÙ¦³¥¦±Ò°Ê«á¶]ªºµ{¦¡¦³­þ¨Ç?
¥H§Ú¦Û¨­¸gÅç¡A¦]¬°¤½¥qºôºÞªº½t¬G¡A¥¦ªººÊ±±µ{¦¡·|¤ñ¸û¦h
¤×¨ä¬O°O¾ÐÅé¤j¤p§ó¬O¼vÅT®Ä¯àªº­«­n¦]¯À
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 10# donald
²M°£DDE....
¤½¥qªº¹q¸£¤@ÂI¤ÏÀ³¤]¨S¦³0.0

TOP

        ÀR«ä¦Û¦b : ¦h°µ¦h±o¡C¤Ö°µ¦h¥¢¡C
ªð¦^¦Cªí ¤W¤@¥DÃD