I am running the ff. script in order to convert ‘file1.xls’ to ‘file2.xlsx’ via a SaveAs method:
$Excel = New-Object -Comobject Excel.Application
$Excel.Visible = $True
$Excel.DisplayAlerts = $False
The script runs and completes without any error messages. When I try to open the resulting file – ‘file2.xlsx’ – EXCEL 2007 (what I have running) gives the error message that the file type or extension is invalid or corrupted. I note that the file ‘file1.xls’ was the result of an export in print mode from MS-ACCESS. There is ONLY ONE WORKSHEET in ‘file1.xls’ to begin with.
Moreover: when I run EXCEL directly on ‘file1.xls’ and then do a SaveAs (to file type .XLSX), it works just fine. Why then is it failing when I run the same steps in the PS script shown? I have PS 5.1, Windows 7 64-bit Ed. platforms.
Would be highly grateful for any advice, tips or hints towards resolving this dilemma. Thanks!