·¢²¼Ê±¼ä£º2015-03-09 À´Ô´£ºÈË´ó¾­¼ÃÂÛ̳

±¾¿Æ±ÏÒµÂÛÎÄ·¶ÎÄ ºêÓëVBAÔڰ칫×Ô¶¯»¯ÖеÄÔËÓà ժ Òª ÔÚÀûÓüÆËã»ú½øÐа칫ԽÀ´Ô½Á÷ÐеĽñÌ죬×Ô¶¯»¯°ì¹«Èí¼þ¼º±»Ô½À´Ô½¶àµÄÈËËù¹Ø×¢¡£ÔõôÑù¸üºÃµØ·¢»ÓÒ»¿î×Ô¶¯»¯°ì¹«Èí¼þµÄ¹¦ÄÜ£¬ÈçºÎ°ÑͬÑùµÄÊÂÇé¸ü¿ì¸üºÃµØ½â¾ö£¬ÊÇÒ»¸öºÜÖµµÃÑо¿µÄÎÊÌâ¡£Excel×÷Ϊһ¿î¹úÄڰ칫Êг¡Õ¼ÓÐÂʷdz£Ö®¸ßµÄ×Ô¶¯»¯°ì¹«Èí¼þ£¬ÓÐ×ÅËüµÃÌì¶ÀºñµÄÓÅÊÆ£¬ÄǾÍÊǼ¯³ÉµÄVBE£¨Visual Basic Editor£©±àÒë»·¾³.ͨ¹ýVBA³ÌÐò´úÂëµÄ±àд£¬²»µ«À©Õ¹ÁËExcelµÄ¹¦ÄÜ£¬Ò²Ê¹µÃÆäÔ­ÓеÄÐí¶à¹¦ÄÜ¿ÉÒÔ¸üºÃµÄÓлú½áºÏÔÚÒ»Æð¡£ ±¾¿ÎÌâÉè¼ÆµÄÈý¸ö×Ô¶¯»¯°ì¹«ÏîÄ¿ºÍÒ»¸ö¼òÒ×µÄÈËʹÜÀíϵͳ£¬ÀûÓü¯³ÉÓÚExcelÖеÄVBE±àÒë»·¾³£¬Í¨¹ýVBA´úÂë±à³Ì£¬Ê¹µÃÔ­±¾¿ÝÔ﷦ζµÄ°ì¹«²Ù×÷£¬±äµÃ¼òÒ×ÇÒ¸ßЧ¡£ ¹Ø¼ü´Ê£ºExcel VBA ×Ô¶¯»¯°ì¹« ¸ßЧ Macros and VBA application in Office Automation Abstract With the rapid development of society, the automate office software has been concerned by people. The article analyses how to play the function of office software and how to make the same thing more effective, which is a notable problem. Excel is a very useful office software which has a high market occupancy. It is integrated VBE £¨ Visual Basic Compiler Editor £©compiling environment. Programming with VBA, which not only extend the function of Excel but also make many of its original function, Excel function can be better combined organically. The three subjects of office automation projects and the easy personnel management system, which use the integrated Excel VBE compiling environment and VBA code programming , become boring business operation to more simple and efficient. Key words: Excel VBA Office Automation Efficiency Ŀ¼ ÖÐÎÄÕªÒª¢ñ Ó¢ÎÄÕªÒª¢ò Ŀ¼¢ó Ç°ÑÔ1 µÚÒ»Õ¸ÅÊö2 1.1°ì¹«×Ô¶¯»¯ÔÚÖйúµÄ·¢Õ¹×´¿ö¼°Ç°¾°2 1.2 ExcelÔڰ칫×Ô¶¯»¯ÖеĹ㷺ÔËÓÃ2 1.3 ºêÓëVBAÔÚExcelÖеÄ×÷ÓÃ3 1.4 Ä¿Ç°°ì¹«Ê¹ÓÃExcelÖдæÔÚµÄÎÊÌâ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­3 1.5 ºêÓëVBAÔڰ칫×Ô¶¯»¯ÖÐÔËÓõĽéÉÜÓëµäÀý¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­4 µÚ¶þÕÂÂÛÎÄ£¨Éè¼Æ£©µÄÀíÂÛ»ù´¡5 2.1 ExcelµÄÊг¡ÐèÇó¼°Óû§Ê¹ÓõÄÏà¹ØÑо¿Óë·ÖÎö5 2.2Ïà¹Ø¿ª·¢¹¤¾ßµÄ½éÉÜ6 2.2.1 Visual Basic for Application±à³ÌÓïÑÔ6 2.2.2 VBAµÄÏà¹ØÀúÊ··¢Õ¹6 2.2.3 VBAµÄ¹¤×÷Ô­Àí¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­6 2.2.4 VBAµÄ¿ª·¢»·¾³¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­7 2.3 Éè¼Æ×ÚÖ¼7 2.3.1 Éè¼ÆÄ¿±ê7 2.3.1-1ͨ¹ýºêÓëVBA£¬¼ò»¯ExcelµÄÆÕͨ²Ù×÷¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­7 2.3.1-2ÔÚExcelÖн¨Á¢µÄ¼òÒ×ÆóÒµÈËʹÜÀíϵͳ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­12 2.3.2 Éè¼Æ¹¦ÄÜ12 2.3.3 ¹¦ÄÜÐÔÐèÇó·ÖÎö13 2.4ϵͳ¿ª·¢Éè¼Æ¿ÉÐÐÐÔ·ÖÎö14 2.5 Êý¾Ý´æ´¢ÓëÏà¹ØÎÊÌâ¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­¡­14 2.6²Ù×÷½çÃæÉè¼Æչʾ14 µÚÈýÕ²¿·Ö´úÂëµÄ·ÖÎö¼°ÎÊÌâ×ܽá18 3.1 ¹ÜÀíϵͳ´úÂë·ÖÎö18 Ô±¹¤ÐÅÏ¢¹ÜÀí¹¦ÄÜÖ÷Òª´úÂë·ÖÎö18 3.2 Ô±¹¤¹ÜÀíϵͳÎÊÌâ×ܽá23 µÚËÄÕ½áÊøÓï25 ÖÂл26 ²Î¿¼ÎÄÏ×27 ¸½Â¼28