½Ð°Ý¦p¦ó¨C¤ëVBA³Ð«Ø¸ê®Æ§¨
- ©«¤l
- 55
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 79
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-7-17
- ³Ì«áµn¿ý
- 2020-12-31
|
½Ð°Ý¦p¦ó¨C¤ëVBA³Ð«Ø¸ê®Æ§¨
¥»©«³Ì«á¥Ñ GBKEE ©ó 2013-7-27 09:09 ½s¿è
¤p§Ì¤£¤~·Q¦Û¦æ»s§@°]°È³øªí¡A¨ä¤º®e¥]¬A¤é³øªí¡B©P³øªí¡B¤ë³øªí
·Q½Ð¦U¦ì¤j¤jÀ°¦£¸Ñ¨Mªº°ÝÃD¦p¤U¡G
1.§Q¥ÎVBA©ó¨C¤ë¤ëªì¶}±Ò°]³øÀɮ׮ɦ۰ʳЫؤ@Ó¥H¤ë¥÷¬°¸ê®Æ§¨¦WºÙ¤§¸ê®Æ§¨
2.¸ê®Æ§¨¨C¤ë©T©w©ó¤ëªì³Ð«Ø¤@¦¸¡A¤º§t¤p§Ì©Ò»s§@ªº¤é³øªí¡B©P³øªí¡B¤ë³øªí¤§ªÅ¥Õªí³æ
3.¨C¤ë©Ò»s§@ªº°]³ø°O¿ý¦Û°ÊÀx¦s©ó¸Ó¤ë¸ê®Æ§¨¤¤
4.¦]°]³ø¬°³sÄò©Ê¤å¥ó¡A¦]¦¹¶·©ó¨C¤ë¤ëªì¸ê®Æ§¨³Ð«Ø®É¡A¦Û°Ê¨ê·s§R°£ªí®æ°O¿ý¤§¸ê®Æ
Y¦³¤j¤j¯àÀ°¦£¸Ñ¨M¤Wz¤§°ÝÃD¡A¤p§Ì·P¿E¸U¤À!! |
|
§A²q!!
|
|
|
|
|
- ©«¤l
- 55
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 79
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-7-17
- ³Ì«áµn¿ý
- 2020-12-31
|
½Ð°Ý¤j¤jConst ªí³æ¸ê®Æ§¨ = "D:\"¬OÄÝ©ó¹w³]Àx¦s¸ô®|
¦p¦ó§âConst ªí³æ¸ê®Æ§¨«ü©w¦bA1Àx¦s®æ¡AÅýÀx¦s®æ¦b¿é¤J¸ô®|«á¥i¥H§ïÅÜÀx¦s¸ô®| |
|
§A²q!!
|
|
|
|
|
- ©«¤l
- 2035
- ¥DÃD
- 24
- ºëµØ
- 0
- ¿n¤À
- 2031
- ÂI¦W
- 0
- §@·~¨t²Î
- Win7
- ³nÅ骩¥»
- Office2010
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2012-3-22
- ³Ì«áµn¿ý
- 2024-2-1
|
¦^´_ 3# bear0925900003
½Ð±N§AªºÀɮפW¶Ç¡A¥H¤è«K¸ÑÃDªÌ¤§¸àÄÀ¡A
ÁÂÁ¡C |
|
|
|
|
|
|
- ©«¤l
- 55
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 79
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-7-17
- ³Ì«áµn¿ý
- 2020-12-31
|
¥i§_±NGBKEE¤j¤j©ó¥»½g´£¥Xªºµ{¦¡½Xµy§@קï¡A±ø¥ó¦p¤U
Option Explicit
'***ªí³æ½d¥».xls (ªÅ¥Õªí³æªº¬¡¶Ã¯)-> ¦]°]³ø¬°³sÄò©Ê¤å¥ó¡A¦]¦¹¶·©ó¨C¤ë¤ëªì¸ê®Æ§¨³Ð«Ø®É¡A¦Û°Ê¨ê·s§R°£ªí®æ°O¿ý¤§¸ê®Æ
Const ªí³æ¸ê®Æ§¨ = "D:\" '¡ö "D:\" ¥i§_«ü©wÀx¦s®æ¤º®e(¦bÀx¦s®æ¤º¿é¤J¸ô®|)
Const ªí³æ¦WºÙ = "³øªí³æ.xls"
Sub Auto_Open()
Dim Fs As Object, xlMonth As String
xlMonth = ªí³æ¸ê®Æ§¨ & Format(Date, "YYYY¦~MM¤ë°]°È³øªí") '¡ö¦p¦ó¨Ï¤é´ÁÅã¥Ü©¹«e¤@Ó¤ë¡A¨Ò¦p¥»¤ë¬°2016¦~12¤ëÅã¥Ü¬°2016¦~11¤ë
If Dir(xlMonth, vbDirectory) = "" Then MkDir (xlMonth)
Set Fs = CreateObject("Scripting.FileSystemObject").GetFile(ªí³æ¸ê®Æ§¨ & "\ªí³æ½d¥».xls")
If Dir(xlMonth & "\" & ªí³æ¦WºÙ) = "" Then Fs.Copy xlMonth & "\" & ªí³æ¦WºÙ
End Sub |
|
§A²q!!
|
|
|
|
|
- ©«¤l
- 55
- ¥DÃD
- 17
- ºëµØ
- 0
- ¿n¤À
- 79
- ÂI¦W
- 0
- §@·~¨t²Î
- XP
- ³nÅ骩¥»
- office2007
- ¾\ŪÅv
- 20
- ©Ê§O
- ¨k
- µù¥U®É¶¡
- 2013-7-17
- ³Ì«áµn¿ý
- 2020-12-31
|
GBKEE¤j©p¯u¬O¯«¤H¡A¦³¦Ò¼{¶}¯Z±Â½Ò¶Ü?§Ú³ø¦W |
|
§A²q!!
|
|
|
|
|