Create Excel file from a Excel Template programmatically

[santony]

Hi,

I have an Excel template and trying to create a copy of the Excel template programmatically.

I would really appreciate if somebody can give some tips to how to get it done.

Thanks,
Antony

 

[RoryA]

Assuming you mean you want to create a workbook based on the template:

workbooks.Add "C:\path to templatel\template name.xlt"

 

[santony]

Your assumption si corrrect and its worked for me.

Thanks Rory.