Hi,
I have bulk data and while copy and pasting data into new workbook using below code, it is creating xls file format and paste function failed. Currently I am working on Excel 2010 version.
Please help how would I assign macro to create new workbook in xlsx format. Thanks in advance.