Option Explicit
Dim sourcepath, destinationpath As String
Dim fso As Object, fl As Object, i As Integer, j As Integer, k As Integer
Sub movefilesfromFolders()
On Error GoTo errorHandler
'return type Application.getopenfile is variant
sourcepath = Application.GetOpenFilename(MultiSelect:=True)
If IsArray(sourcepath) = True Then
Set fso = New Scripting.FileSystemObject
Application.FileDialog(msoFileDialogFolderPicker).Show
destinationpath = Application.FileDialog(msoFileDialogFolderPicker).SelectedItems(1) & "\"
For i = LBound(sourcepath) To UBound(sourcepath)
fso.movefile sourcepath(i), destinationpath & fso.GetFileName(sourcepath(i))
Next
Else
MsgBox "File not selected"
End If
Exit Sub
errorHandler:
MsgBox "Error" & Err.Description
End Sub
Dim sourcepath, destinationpath As String
Dim fso As Object, fl As Object, i As Integer, j As Integer, k As Integer
Sub movefilesfromFolders()
On Error GoTo errorHandler
'return type Application.getopenfile is variant
sourcepath = Application.GetOpenFilename(MultiSelect:=True)
If IsArray(sourcepath) = True Then
Set fso = New Scripting.FileSystemObject
Application.FileDialog(msoFileDialogFolderPicker).Show
destinationpath = Application.FileDialog(msoFileDialogFolderPicker).SelectedItems(1) & "\"
For i = LBound(sourcepath) To UBound(sourcepath)
fso.movefile sourcepath(i), destinationpath & fso.GetFileName(sourcepath(i))
Next
Else
MsgBox "File not selected"
End If
Exit Sub
errorHandler:
MsgBox "Error" & Err.Description
End Sub
No comments:
Post a Comment