¦p¦óÃö³¬¾ãÓ EXCEL ¦ý¸T¤î¸ß°Ý¬O§_n¦sÀÉ
- ©«¤l
- 319
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 309
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- 2k
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-6-24
- ³Ì«áµn¿ý
- 2024-4-27
|
¦p¦óÃö³¬¾ãÓ EXCEL ¦ý¸T¤î¸ß°Ý¬O§_n¦sÀÉ
Ãö³¬EXCEL ®É, ¦pªG¸ê®Æ¦³ÅÜ°Ê, EXCEL ·|°Ý§An¤£n¦sÀÉ
«ç¼Ë¤~¯àÅý EXCEL ¤£¸ß°Ý©O
¥H¤U¼gªk·Ó¼Ë·|°T°Ý
Application.DisplayAlerts = False
Application.Quit |
|
|
|
|
|
|
- ©«¤l
- 471
- ¥DÃD
- 121
- ºëµØ
- 0
- ¿n¤À
- 579
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN10
- ³nÅ骩¥»
- OFFICE2019
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-4-16
- ³Ì«áµn¿ý
- 2023-1-17
|
Ãö³¬EXCEL ®É, ¦pªG¸ê®Æ¦³ÅÜ°Ê, EXCEL ·|°Ý§An¤£n¦sÀÉ
«ç¼Ë¤~¯àÅý EXCEL ¤£¸ß°Ý©O
¥H¤U¼gªk·Ó¼Ë·|°T ...
jackyq µoªí©ó 2015-7-17 14:02
ActiveWorkbook.Close True '¦sÀÉ
ActiveWorkbook.Close false '¤£¦sÀÉ |
|
|
|
|
|
|
- ©«¤l
- 319
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 309
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- 2k
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-6-24
- ³Ì«áµn¿ý
- 2024-4-27
|
¦^´_ 2# starry1314
±µµÛ§ÚÁÙn§â EXCEL ¾ãÓÃö³¬, ¤£¬O¥u¦³Ãö³¬ WorkBook |
|
|
|
|
|
|
- ©«¤l
- 552
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 578
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office 2010
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-2-8
- ³Ì«áµn¿ý
- 2024-7-9
|
¦^´_ 3# jackyq
¦bExcel»¡©ú½d¨Ò´N¦³¤F¦p¤U
For Each w In Application.Workbooks
w.Save
Next w
Application.Quit |
|
|
|
|
|
|
- ©«¤l
- 319
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 309
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- 2k
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-6-24
- ³Ì«áµn¿ý
- 2024-4-27
|
¥»©«³Ì«á¥Ñ jackyq ©ó 2015-7-17 17:40 ½s¿è
¦^´_ 4# lpk187
hi
§Únªº¬O¤£¦sÀɵM«áÃö³¬¾ãÓ EXCEL ¥B ¤£¯àÅý EXCEL ¼u¥X¸ß°Ý¬O§_¦sÀɪº MsgBox |
|
|
|
|
|
|
- ©«¤l
- 319
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 309
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- 2k
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-6-24
- ³Ì«áµn¿ý
- 2024-4-27
|
¦^´_ jackyq
GBKEE µoªí©ó 2015-7-17 18:54
hi ~
³o¼Ë¥u·|Ãö³¬ WorkBook
§Ú³s EXCEL ¤]n¤@°_³QÃö³¬ |
|
|
|
|
|
|
- ©«¤l
- 552
- ¥DÃD
- 3
- ºëµØ
- 0
- ¿n¤À
- 578
- ÂI¦W
- 0
- §@·~¨t²Î
- win7
- ³nÅ骩¥»
- office 2010
- ¾\ŪÅv
- 50
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-2-8
- ³Ì«áµn¿ý
- 2024-7-9
|
¥»©«³Ì«á¥Ñ 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 |
|
|
|
|
|
|
- ©«¤l
- 319
- ¥DÃD
- 6
- ºëµØ
- 0
- ¿n¤À
- 309
- ÂI¦W
- 0
- §@·~¨t²Î
- xp
- ³nÅ骩¥»
- 2k
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2015-6-24
- ³Ì«áµn¿ý
- 2024-4-27
|
¦^´_ 8# lpk187
¹ïC! ³æ¿W³oÓ½d¨Ò¬O ok
®M¦b§Úªº xls ÀÉ, ´N¥¢®Ä¤F
¨º§Ún§ä§äì¦]¬°¦ó§Úªº xlsÀÉ«o·|¥¢®Ä |
|
|
|
|
|
|