VBA Excel: Create new excel file (xls, xlsx)

If you need to create a new workbook with the collected data from Userform or existing data in the source workbook/worksheet, use the below code. This code will sense the application version (Ms2003, Ms2007 and above) and create the new excel file.