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

¦p¦óÃö³¬¾ã­Ó EXCEL ¦ý¸T¤î¸ß°Ý¬O§_­n¦sÀÉ

¦p¦óÃö³¬¾ã­Ó EXCEL ¦ý¸T¤î¸ß°Ý¬O§_­n¦sÀÉ

Ãö³¬EXCEL ®É, ¦pªG¸ê®Æ¦³ÅÜ°Ê,  EXCEL ·|°Ý§A­n¤£­n¦sÀÉ
«ç¼Ë¤~¯àÅý EXCEL ¤£¸ß°Ý©O

¥H¤U¼gªk·Ó¼Ë·|°T°Ý
Application.DisplayAlerts = False
Application.Quit

Ãö³¬EXCEL ®É, ¦pªG¸ê®Æ¦³ÅÜ°Ê,  EXCEL ·|°Ý§A­n¤£­n¦sÀÉ
«ç¼Ë¤~¯àÅý EXCEL ¤£¸ß°Ý©O

¥H¤U¼gªk·Ó¼Ë·|°T ...
jackyq µoªí©ó 2015-7-17 14:02

ActiveWorkbook.Close True  '¦sÀÉ
ActiveWorkbook.Close false  '¤£¦sÀÉ

TOP

¦^´_ 2# starry1314
   

    ±µµÛ§ÚÁÙ­n§â EXCEL ¾ã­ÓÃö³¬,  ¤£¬O¥u¦³Ãö³¬ WorkBook

TOP

¦^´_ 3# jackyq

¦bExcel»¡©ú½d¨Ò´N¦³¤F¦p¤U
For Each w In Application.Workbooks
    w.Save
Next w
Application.Quit

TOP

¥»©«³Ì«á¥Ñ jackyq ©ó 2015-7-17 17:40 ½s¿è

¦^´_ 4# lpk187

hi

§Ú­nªº¬O¤£¦sÀɵM«áÃö³¬¾ã­Ó EXCEL ¥B ¤£¯àÅý EXCEL ¼u¥X¸ß°Ý¬O§_¦sÀɪº MsgBox

TOP

¦^´_ 5# jackyq
  1. W.Close False
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¦^´_  jackyq
GBKEE µoªí©ó 2015-7-17 18:54


hi  ~
³o¼Ë¥u·|Ãö³¬ WorkBook
§Ú³s EXCEL ¤]­n¤@°_³QÃö³¬

TOP

¥»©«³Ì«á¥Ñ lpk187 ©ó 2015-7-17 20:17 ½s¿è

¦^´_ 5# jackyq


    ­è¶}©l¨S¬Ý²M·¡§Aªº°ÝÃD¡A­è¸Õ¤F¤@¤U§A­ì¨Óªº¼gªk
Application.DisplayAlerts = False
Application.Quit
¤£·|¦³Åã¥Ü¸ß°Ýµøµ¡¡A¤]¤£·|Àx¦sÀÉ®×°Ú¡I
¦Ó¥B§Ú¤º®e³£¦³ÅÜ°Ê¡I¡I
¦A¥´¶}®É©M¨SÅܰʤ@¼Ë¡I¡I

TOP

¦^´_ 8# lpk187


¹ï­C!   ³æ¿W³o­Ó½d¨Ò¬O ok

®M¦b§Úªº xls ÀÉ, ´N¥¢®Ä¤F

¨º§Ú­n§ä§ä­ì¦]¬°¦ó§Úªº xlsÀÉ«o·|¥¢®Ä

TOP

        ÀR«ä¦Û¦b : ¡i®É¶¡¦pÆp¥Û¡j®É¶¡¹ï¤@­Ó¦³´¼¼zªº¤H¦Ó¨¥¡A´N¦pÆp¥Û¯ë¬Ã¶Q¡F¦ý¹ï·M¤H¨Ó»¡¡A«o¹³¬O¤@§âªd¤g¡A¤@ÂI»ù­È¤]¨S¦³¡C
ªð¦^¦Cªí ¤W¤@¥DÃD