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

[µo°Ý] ½Ð±Ð¦U¦ì¤j¤j¦sÀÉ

[µo°Ý] ½Ð±Ð¦U¦ì¤j¤j¦sÀÉ

¦U¦ì«e½ú¡A¤p§Ì¦³­Ó°ÝÃD·Q½Ð±Ð

Excel VBA¥t¦s·sÀÉ¡A¥i¥H³]©w¸ô®|©MÀɮצWºÙ¥H¤Î°ÆÀɦW¡A¦sÀɪº®É­Ô¤£¥X²{´£¥Üµøµ¡ª½±µ°õ¦æ

¤p§Ì¦b³o³Â·Ð¦U¦ì¤j¤j¡A·P®¦¤F

¦^´_ 1# EGBT

Application.DisplayAlerts = False'¨ú®øĵ§i(¦p¤w¸g¦s¦bÀÉ®×,·|ª½±µÂл\)
ActiveWorkbook.SaveAs (c:\"xxxx.xlsm")
Application.DisplayAlerts = true '°O±o«ì´_ĵ§i¥\¯à
¤@¯ë²{¦b¦³µ{¦¡½Xªº³£¬O¨Ï¥Îxlsm·í§@°ÆÀɦW
°£«D§A·Q§ó´«¬°xlsb,xls «h»Ý­n¤£¦Pªº»yªk
­Y±z¬Oª©ªº,«h§â¤W­z»yªk§ï¬°.xls§Y¥i

¥H¤W½Ð¸Õ¸Õ¬Ý
PKKO

TOP

        ÀR«ä¦Û¦b : ¶¢¤HµL¼Ö½ì¡A¦£¤HµL¬O«D¡C
ªð¦^¦Cªí ¤W¤@¥DÃD