topic Convert workbooks to .xlsx format from macro in Water Cooler https://community.qlik.com/t5/Water-Cooler/Convert-workbooks-to-xlsx-format-from-macro/m-p/719682#M3358 <HTML><HEAD></HEAD><BODY><P>Hi everybody! I have a macro to convert files to .xlsx format. The problem is that convert the files to .xls and not to .xlsx. The line is:</P><P></P><P>objExcel.ActiveWorkbook.SaveAs(CurrentDirectory &amp; FileName), FileFormat= xlOpenXMLWorkbook</P><P></P><P>Thank you!!</P></BODY></HTML> Mon, 21 Jul 2014 15:42:18 GMT 2014-07-21T15:42:18Z Convert workbooks to .xlsx format from macro https://community.qlik.com/t5/Water-Cooler/Convert-workbooks-to-xlsx-format-from-macro/m-p/719682#M3358 <HTML><HEAD></HEAD><BODY><P>Hi everybody! I have a macro to convert files to .xlsx format. The problem is that convert the files to .xls and not to .xlsx. The line is:</P><P></P><P>objExcel.ActiveWorkbook.SaveAs(CurrentDirectory &amp; FileName), FileFormat= xlOpenXMLWorkbook</P><P></P><P>Thank you!!</P></BODY></HTML> Mon, 21 Jul 2014 15:42:18 GMT https://community.qlik.com/t5/Water-Cooler/Convert-workbooks-to-xlsx-format-from-macro/m-p/719682#M3358 2014-07-21T15:42:18Z Re: Convert workbooks to .xlsx format from macro https://community.qlik.com/t5/Water-Cooler/Convert-workbooks-to-xlsx-format-from-macro/m-p/719683#M3359 <HTML><HEAD></HEAD><BODY><P>Qlikview supoorts format .xlsx? Because converts only to .xls with this macro.</P></BODY></HTML> Wed, 23 Jul 2014 16:56:45 GMT https://community.qlik.com/t5/Water-Cooler/Convert-workbooks-to-xlsx-format-from-macro/m-p/719683#M3359 2014-07-23T16:56:45Z