| |
▼SHO さん：
FSOを使ったほうが、そちらのコードにあうのでしょうが、標準機能だけで。
フォルダは、実際のものにしておいてください。
Sub Test()
Dim SFolder As String
Dim DFolder As String
Dim fName As String
Dim z As String
Dim ym1 As String
Dim ym2 As String
Dim ym As String
Dim tmp1 As Variant
Dim tmp2 As Variant
Dim ok As Boolean
z = Range("C8").Value
ym1 = Format(DateSerial(Left(z, 4), Mid(z, 5), 1), "yyyymm")
ym2 = Format(DateSerial(Left(z, 4), Mid(z, 5) + 1, 1), "yyyymm")
SFolder = CreateObject("WScript.Shell").SpecialFolders("DeskTop") & "\SFolder\"
DFolder = CreateObject("WScript.Shell").SpecialFolders("DeskTop") & "\DFolder\"
fName = Dir(SFolder & "*.xml")
Do While fName <> ""
tmp1 = Split(fName, "_")
tmp2 = Split(tmp1(UBound(tmp1)), ".")
ok = False
ym = tmp2(LBound(tmp2))
Select Case Left(ym, 6)
Case ym1
If Right(ym, 2) <> "01" Then ok = True
Case ym2
If Right(ym, 2) = "01" Then ok = True
End Select
If ok Then
On Error Resume Next
Kill DFolder & fName
On Error GoTo 0
FileCopy SFolder & fName, DFolder & fName
End If
fName = Dir()
Loop
End Sub
|
|
![[未読]](./data/excel/image/read_icon.gif){kind=icon}
