Home > VBAUsefulCodes
Copy Files using File System Object from one place to another.
Copy a File from One Place to Another using File System Object
Copy Files using File System Object from one place to another.
' Add Reference to Microsoft Scripting Runtime
Sub CopyFile()
Dim MyFSO As FileSystemObject
Dim SourceFile As String
Dim DestinationFolder As String
Set MyFSO = New Scripting.FileSystemObject
SourceFile = "C:\SourceFile.xlsx"
DestinationFolder = "C:\Destination"
MyFSO.CopyFile Source:=SourceFile, Destination:=DestinationFolder & "\SourceFile.xlsx"
End Sub
Subscribe
More to Explore
Tags
VBA Outlook KPI Excel Alt+F11 Dashboards Macros Recording Graphs Automation Developer WaterFall Powerpoint Charts Pivot Tables Forecast Charts