Update the data in Excel files

UpdateExcel.ps1

$dir = "c:\temp\" + (Get-Date).ToString("yyyy-MM-dd")
Write-Host $dir
$excelObj = New-Object -ComObject Excel.Application
$excelObj.Visible = $true

$files = Get-ChildItem -Path $dir
foreach ($file in $files)
{
    $filePath = $file.FullName
    $workBook = $excelObj.Workbooks.Open($filePath)
    $workBook.RefreshAll()
    $workBook.Save()
    $workBook.Close()
}
$excelObj.Quit()