Script to copy MS Excel files from one location to another and keep a log

Hi ChrisC365,

Could you try this?

# Input Parameters
$Date = Get-Date -Format "dd-MM-yyyy-dddd HH-mm"
$SrcFile1 = "filename1.xlsx"
$SrcFile2 = "filename2.xlsx"
$Srcfolder = "C:\Source\"
$Dstfolder = "C:\Destination\"
$Logs = "C:\Logs\"


# Copy Files From Source to Destination

    Try
    {
    Write-Host "Copying the $SrcFile1" -ForegroundColor Yellow 
    Copy-Item -Path "$SrcFolder\$SrcFile1" -Recurse -Destination "$DstFolder\$Date - $SrcFile1" -ErrorAction SilentlyContinue
    Write-Host "Completed" -ForegroundColor Green
    }
    
    Catch
    {
    Write-Host "$SrcFile1 is not copied. Log File is in $Logs" -ForegroundColor Red
    Add-Content "$Logs\Log - $Date.txt" -Value "$SrcFile1 not copied because $($Error[0])"
    } 

    Try
    {
    Write-Host "Copying the $SrcFile2" -ForegroundColor Yellow 
    Copy-Item -Path "$SrcFolder\$SrcFile2" -Recurse -Destination "$DstFolder\$Date - $SrcFile2" -ErrorAction SilentlyContinue
    Write-Host "Completed" -ForegroundColor Green
    }
    
    Catch
    {
    Write-Host "$SrcFile2 is not copied. Log File is in $Logs" -ForegroundColor Red
    Add-Content "$Logs\Log - $Date.txt" -Value "$SrcFile2 not copied because $($Error[0])"
    }