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

[­ì³Ð] Excel ©w¸qÆ[©À(Excel À³¥Î ­Ó§O§Þ³N)½d¨Ò:Excel½Òµ{-ÅçÃÒ-À³¥Î-¥À¤l¼hÅçÃÒ

[­ì³Ð] Excel ©w¸qÆ[©À(Excel À³¥Î ­Ó§O§Þ³N)½d¨Ò:Excel½Òµ{-ÅçÃÒ-À³¥Î-¥À¤l¼hÅçÃÒ

©«²¾Âà
©w¸q¥i¤À¦¨
1. ÁôÂûP«DÁôÂÃ(¨t²Î»P«D¨t²Î)
2. ¨Ì¶}±Ò»P¨Ï¥ÎSHEETÁÙ¥i¦A¤À¦¨¦Û°Ê±Ò¥Î»P«D¦Û°Ê±Ò¥Î¨âºØ
3. ¨Ì¨Ï¥Î¤¤SHEETÁÙ¥i¦A¤À¦¨¨p¥Î»P¤½¥Î
4. ¨Ì¨Ï¥Î¤¤°Ï°ìÁÙ¥i¦A¤À¦¨µ´¹ï¬Û¹ï»P¦@¥Î¤TºØ

¦ó¿×ÁôÂûP«DÁôÂÃ(¨t²Î»P«D¨t²Î)
²³æªº»¡´N¬O¬Ýªº©w¸q»P¬Ý¤£¨ì©w¸q (­þ¸Ì¥i¥H¬Ýªº¨ì³o¨Ç!(AºK­n¸ê°T B¸ê®Æ½s¿è¦C C´¡¤J¶W³sµ² D´¡¤J©w¸qµ¥µ¥)¦³¨Ç¬O¨t²Î¦Û°Ê²£¥Íªº©w¸q ¦p:¦C¦L½d³ò ¶i¶¥¿z¿ï³£¦³¦ý¤j³¡¤À³£¬OÁôÂ꺧ڭ̬ݤ£¨ì ³o³¡¤À±`¯d¤U¤£¥²­nªº¸ê°T©U§£

¥i§_¦Û¤vÁôÂéw¸q µª®×¬O¥i¥Hªº ¤èªk¦³¨â­Ó
• ◦ ¤@¥¨¶°ªí(§»ªí)  ¤Ö¤H¥Î¦¹³B¤£»¡©ú
◦ ¤GVBA ¨Ï¥ÎActiveWorkbook.Names("SHEET").Visible = True §@©w¸qÁôÂÃÅã²{°Ê§@
◦ ­È±oª`·Nªº¬O¥Î¥¨¶°ªí(§»ªí)  §@¨ç¼Æ®É ÁôÂéw¸q¨ç¼Æ ¥Lªº¨ç¼Æ»¡©ú¤£·|Åã¥Ü


¦ó¿×¨Ì¶}±Ò»P¨Ï¥ÎSHEETÁÙ¥i¦A¤À¦¨¦Û°Ê±Ò¥Î»P«D¦Û°Ê±Ò¥Î¨âºØ
¦¹³B¬O»¡©ú¥¨¶°ªí(§»ªí) ªº¦Û°Ê©w¸q³¡¤À¦pAuto_Open  Auto_Close Auto_Activate Auto_Deactivate

¦ó¿×¨Ì¨Ï¥Î¤¤SHEETÁÙ¥i¦A¤À¦¨¨p¥Î»P¤½¥Î
¦¹³B¬O»¡©ú¬O¥u¦³«ü©wªº³æ¤@Sheet¥i¥H¥Î  ©w¸q¦WºÙ°Ï¥Î("sheet1'!©w¸q¦WºÙ)ªí¥Ü ÁÙ¬O¾ã­ÓWorkbook¥i¥H¥Î ©w¸q¦WºÙ°Ï¥Î(©w¸q¦WºÙ)ªí¥Ü ­È±oª`·Nªº¬OOffice2007¦b³o¤è­±ªº¤À³¥¦¹³B¦³§@«Ü¤jªº§ïµ½ ¥i¥H¿ï¾Ü³æ¤@Sheet©ÎWorkbook¤£¥Î¦A¥Î¤â¥´¦r¤F

¦ó¿×¨Ì¨Ï¥Î¤¤°Ï°ìÁÙ¥i¦A¤À¦¨µ´¹ï¬Û¹ï»P¦@¥Î¤TºØ
¦¹³B¬O»¡©ú¦b©w¸q½d³òªº®É­Ô¸ò¤½¦¡¤@¼Ë¦³µ´¹ï»P¬Û¹ïªºÃö«Y»PÆ[©À ¦p:sheet1'!$a$1:$b$5 sheet1'!a1:b5¦Ó¤°»ò¬O¦@¥Î ¦@¥Î´N¬O§Q¥Î¦P¼Ëªº©w¸q¥i¥H¤Þ¥Î¤£¦PSheetªº¸ê®Æ¦p!$a$1:$b$5¤£¿é¤JSheet¦WºÙ
¥H¤W­zÆ[©À¦A®M¨ì¦U¥\¯à¥hÀ³¥Î
§ä­Ó©w¸q½d¨Ò§a³o¬O§Ú°µªº¡@±N©w¸q½Æ¦X¨ìÅçÃÒ¤¤¡@¬O¦h¼hÅçÃÒ ©ñ¦b¤å¥ó¸Ì­±
2008341411109.rar (4.11 KB)

        ÀR«ä¦Û¦b : ¯u¥¿ªº·R¤ß¡A¬O·ÓÅU¦n¦Û¤vªº³oÁû¤ß¡C
ªð¦^¦Cªí ¤W¤@¥DÃD