|
本帖最后由 ykcbf1100 于 2024-6-14 18:47 编辑
练习。。。。。- Sub ykcbf() '//2024.6.14,按要求归类月份文件
- '//**************************************************
- '// 说明:
- '// 1、自动建立任意二月的对应子目录
- '// 2、把月份文件复制到对应的子目录中
- '// 3、把汇总文件复制进对应子目录中,并把文件名改为与子目录同名
- '//******************************************************
- Application.ScreenUpdating = False
- Application.DisplayAlerts = False
- Set fso = CreateObject("scripting.filesystemobject")
- Set d = CreateObject("Scripting.Dictionary")
- p = ThisWorkbook.Path & ""
- For Each f In fso.GetFolder(p).Files
- fn = fso.GetBaseName(f)
- If Val(fn) Then
- s = Replace(Split(fn, "-")(0), "月", "")
- d(s) = ""
- End If
- Next f
- For x = 1 To d.Count - 1
- For y = 2 To d.Count
- If x < y Then
- fd = x & "-" & y & "汇总"
- p1 = p & fd
- If Not fso.FolderExists(p1) Then fso.CreateFolder p1
- For Each f In fso.GetFolder(p).Files
- fn = fso.GetBaseName(f)
- If x = Val(fn) Or y = Val(fn) Then
- fso.CopyFile f, p1
- End If
- Next f
- f1 = p & "汇总.xlsm"
- fso.CopyFile f1, p1
- For Each f In fso.GetFolder(p1).Files
- fn = fso.GetBaseName(f)
- If fn = "汇总" Then f.Name = Replace(fd, "", ".xlsm")
- Next
- End If
- Next
- Next
- Application.ScreenUpdating = True
- MsgBox "OK!"
- End Sub
复制代码
|
评分
-
1
查看全部评分
-
|