Create Excel file from a Excel Template programmatically

santony

New Member
Joined
Aug 5, 2010
Messages
7
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
 

Some videos you may like

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,692
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
Assuming you mean you want to create a workbook based on the template:
Code:
workbooks.Add "C:\path to templatel\template name.xlt"
 

Watch MrExcel Video

Forum statistics

Threads
1,090,108
Messages
5,412,460
Members
403,428
Latest member
ldmcd

This Week's Hot Topics

Top