Automated Excel File Creation with VBA

[msiyab]

Hi Guys,

I would like to know if its possible to create a command button to create a new excel file.
I have a voucher generator excel file, which generates vouchers on each sheet. So at the end of each month, i would like to create a new excel file for the next month with just the first two sheets of the 100+ worksheets in the new excel file. This would be helful as i have over 50 such files which need to be renamed and modified each month. It would be nice if the command button would ask me to name the file before creating it.

I would like to modify 3-4 cells in this workbook, but will mention them only if the above mentioned is possible.
I am attaching the template file for your reference.


Regards,
Siyab