Convert excel file format xls to xlsx
I have some reports arriving to me in xls format, but I would like winautomation to automatically convert format to xlsx.
Any idea? Many thanks!
There are multiple ways to perform this tasks:
(i) Through Excel actions - Open each file and rename it.
(ii) Through VBscript
Without opening the file, you can rename it through Command prompt using "REN" command.
Syntax: Ren [full path including the file extension] [new filename/extension]
Eg: Ren C:\Users\ABC\Desktop\Example_Sheet.xlsx Example_Sheet.xls
I hope this helps in resolving your issue.
Open them one at a time and save them as the new preferred format.
Find me on LinkedIn if you need instruction :)