I am using Powershell scripts to run Excel 2013 on a Windows 2012 server and save the spreadsheets as 2003 .xls workbooks.
If I use the $xlNormal = 51, then the spreadsheets save correctly as .xlsx workbooks which I cannot use in the next stage.
I have tried $xlNormal = 43 where an exception “SaveAs method of Workbook class failed”
With $xlNormal = 29 Excel does not create any output file and hangs until I do a stop-process
With $xlNormal = 56 I see a temporary file with no type being created with size 1K and Excel hangs until I do a stop-process
I have to create the earlier version of .xls file as these are read by a system that uses Excel 2003 using complex macros.
What am I doing wrong and how do I save with the old formats.
I have included the working parts of the script.