Sub pnt_list()
Dim fs, a
Dim FSO
Dim sFile As String
Dim sSFolder As String
Dim sDFolder As String
Set FSO = CreateObject("Scripting.FileSystemObject")
On Error Resume Next
Set fs = CreateObject("Scripting.FileSystemObject")
Set a = fs.CreateFolder("C:\Apps\Print\")
On Error GoTo 0
Dim sc As Range
For Each sc In ActiveSheet.Range("A3:A" & Cells(Rows.Count, "A").End(xlUp).Row)
If sc.Value = True Then
sc.Offset(0, 7).Select
'This is Your File Name which you want to Copy
sFile = ActiveCell.Value
'Change to match the source folder path
sSFolder = ActiveCell.Offset(0, -1).Value
'Change to match the destination folder path
sDFolder = "C:\Apps\Print\"
''Checking If File Is Located in the Source Folder
' If Not FSO.FileExists(sSFolder & sFile) Then
''Copying If the Same File is Not Located in the Destination Folder
' ElseIf Not FSO.FileExists(sFile) Then
FSO.CopyFile (sSFolder & sFile), sDFolder, True
Else
End If
Next sc
End Sub
Got it!
Bookmarks