Scrap

From Piszczynski
Revision as of 22:32, 15 November 2023 by Aleks (talk | contribs) (1 revision imported)
(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()

}