Scrap: Difference between revisions

From Piszczynski
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...")
 
m (1 revision imported)
 
(No difference)

Latest revision as of 22:32, 15 November 2023

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()

}