We are using Excel automation to generate a daily item status report. By default the file that is generated is in the new xlsx format. But we would like to save the file as xls. Is this possible with automations?
For the automation we are using Microsoft Excel 12.0 Object Library, maybe we need an older library?
0
Comments
You can use SaveAs command. Have a look here for details:
http://www.rondebruin.nl/saveas.htm
Hope this helps
Thomas
Cool, the fileformat expression was exactly what I was looking for. Thanks!
Felix