|
|
发表于 2011-8-9 00:38:18
|
显示全部楼层
本帖最后由 ArdentMan 于 2011-8-9 00:40 编辑
VBS方案:
- Dim NowYear, NowWeek, NowWeekDay, Arr, FolderName, FSO, Path
- Arr = split("Sunday,Monday,Tuesday,Wednesday,Thursday,Friday,Saturday", ",")
- NowYear = Year(Now())
- NowWeek = DateDiff("ww", NowYear & "-1-1", Now())
- NowWeekDay = Arr(Weekday(Now()))
- FolderName = NowYear & "_" & NowWeek & "_" & NowWeekDay
- Set FSO = CreateObject("Scripting.FileSystemObject")
- Path = CreateObject("Wscript.Shell").CurrentDirectory & ""'如不是当前目录请自行修改为绝对或相对路径
- FSO.CreateFolder FolderName
- For Each file In FSO.GetFolder(Path).Files
- If LCase(FSO.GetExtensionName(file)) = "csv" Then FSO.CopyFile file, FolderName & ""
- Next
- Set FSO = Nothing
- MsgBox "拷备完成" ,, "ArdentMan友情提示"
复制代码 |
评分
-
查看全部评分
|