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

[µo°Ý] ¬O§_¯à±j¨î¹q¸£ªº¦h®Ö¤ß"°ª®Ä¯à"¥h°õ¦æµ{¦¡

[µo°Ý] ¬O§_¯à±j¨î¹q¸£ªº¦h®Ö¤ß"°ª®Ä¯à"¥h°õ¦æµ{¦¡

¦U¦ì«e½ú¦n¡A¬O³o¼Ëªº§Ú¦³¤@­ÓVBAµ{¦¡¦b¤£¦P¹q¸£¤W°õ¦æ®Ä²v¤£¦P(¦n¹q¸£¤Ï¦Ó¤ñ¸ûºC....ºC«D±`¦h)¡A
EXCEL¦³³]©w¶}±Ò¦h°õ¦æºü¡A¥Bwin10.excel¬Ò64¦ì¤¸
A¹q¸£¡G4C8T(¥B³æ®Ö®Ä¯à¶]¤À©úÅã±j¹L©óB¹q¸£) E3-1230
B¹q¸£¡G2C4T  I3-4130

A¹q¸£°õ¦æµ{¦¡®É(³z¹L¥H¤U³]©w ¶]«ü©wªºVBA¬Ò¯Ó®É2¤À30¬í¥ª¥k)
µL¯S®í³]©w¡G8T«o¥u¶]³æ®ÖµM«áº¡¸ü90%¥H¤W
³]©wÀu¥ý¶¶§Ç¬°§Y®É¡G8T¥þ¶]¦ý....¦UT¥u¶]10%....¦Ó¥B¹ê»Ú¹B¦æ¶WºC
³]©w¿Ë©M©Ê¬°6®Ö¡G6T¥þ¶]¦ý¹B§@¤j·§¤£¨ì20%....¹ê»Ú¹B¦æ®É¶¡¤´µM¶WºC

B¹q¸£(¯Ó®É1¤À30¬í¥ª¥k§Y¥i¶]§¹)
µL¯S®í³]©w¡G4T¥þ¶]¡A¦U®Ö¬ù50%¹B§@

¦³¤Hª¾¹D¬O¤°»ò­ì¦]¶Ü? ©Î¬O¦³µL³]©w¯à°÷¶}±Ò´£°ª®Ö¤ßªº®Ä¯à

¿ï¶µ -> ¶i¶¥ -> ¤½¦¡ -> ±Ò¥Î¦h°õ¦æºü­pºâ¡A©Î¬O¥i¥H°Ñ¦Ò¡G
msdn.microsoft.com/zh-tw/library/office/ff726673(v=office.14).aspx
msdn.microsoft.com/zh-tw/library/office/ff700515(v=office.14).aspx
Tanlee

TOP

¥»©«³Ì«á¥Ñ luckeyfly ©ó 2019-1-2 13:21 ½s¿è

¦h®Ö¤ß­n¹ïÀ³ªº¬O¦h°õ¦æ§Ç
²³æªº»¡¡A§Aªºµ{¦¡«ü¥O¦b¼¶¼g®É¥²¶·¬O¯à°÷¤À¬q¥B¦h¬q¦P¨B°õ¦æªº¡A¤~¯à¦b¦h®Ö¤ß¤Wµo´§®ÄªG
¦pªG«ü¥O¤£¯à¤À¬q¡A´N¥u¯à¥æµ¹¤@­Ó®Ö¤ß¥h¶]
©Ò¥H¶R¹q¸£®É°£¤F¬Ý¦h®Ö¤ß®Ä¯à¡AÁÙ¦³¤H·|¨è·N¬D¿ï³æ®Ö¤ß®Ä¯à

EXCEL¥»¨­ÁöµM¤ä´©¦h®Ö¤ß¡A¦ý¨Ã¤£¬O¥þ³¡«ü¥O³£¥i¥H¦h®Ö¤ß¹B§@
¤@±i¤u§@ªí¤Wªº«Ü¦h¡u¿W¥ß¡vªºÀx¦s®æ¹Bºâ¦¡¡A¥i¥H¦h®Ö¤ß¦P¨B¹B§@
¦ý¬OVBA«ü¥O¤j³¡¤À³£¥u¯à³æ®Ö¤ß¹B§@


¦Ü©óCPU±±¨î
Àu¥ý¶¶§Ç±±¨îªº¬OCPU¹Bºâ®É¶¡ªº¤À°t¡]«e´ºµ{¦¡/­I´ºµ{¦¡¡^¡A¦bCPU¤£¬Oº¡¸üªº±¡ªp¤U¡A³]©wÀu¥ý¶¶§Ç°ò¥»¤W¤£¼vÅT®Ä¯à
¥i¥H­­¨îCPU®Ö¤ß¼Æ¤]¨S¦³·N¸q¡A¦]¬°´î¤Ö®Ö¤ß¼Æ¨Ã¤£·|¦P¨B´£¤É®É¯ß(®É¯ß¤£´£¤É¡A³æ®Ö®Ä¯à´N¤£´£¤É)
¡ãºµ¿ß¬É²Ä¤@¬ü¨k¤l¡ã

TOP

¥i¥H¸Õ¸Õ¬Ý½Õ¾ã¹q¸£®Ä¯à³¡¥÷¥u¤¹³\°õ¦æµ{¦¡°ª¨ä¥L¤£¥Î­I´ºµ{¦¡ªº¥ý¦æÃö³¬

TOP

³o¬O§Ú¤ß¤¤¤@ª½ªººÃ´b¡I¦ý¬OÅ¥¨ìªºÄÀºÃ¤j³£¬O²z½×¬£ªº¦h,¦³¨S¦³ªB¤Í¯à°÷Á|­Óstep by stepªº½Õ¾ã¹ê¨Ò,¡]µæ³¾¾Ç²ß¤¤¡^

TOP

        ÀR«ä¦Û¦b : §Ñ¥\¤£§Ñ¹L¡A§Ñ«è¤£§Ñ®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD