Scrap

From Piszczynski
Revision as of 18:21, 11 November 2020 by piszczynski>Aleks (Created page with "foreach($file in (Get-ChildItem "C:\temp")) { $newname = $file.FullName -replace '\.xls$', '.csv' $ExcelWB = new-object -comobject excel.application $Workbook = $ExcelW...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

foreach($file in (Get-ChildItem "C:\temp")) {

 $newname = $file.FullName -replace '\.xls$', '.csv'
 $ExcelWB = new-object -comobject excel.application
 $Workbook = $ExcelWB.Workbooks.Open($file.FullName) 
 $Workbook.SaveAs($newname,6)
 $Workbook.Close($false)
 $ExcelWB.quit()

}