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

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

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,089,994
Messages
5,411,716
Members
403,394
Latest member
Mohan Kumar

This Week's Hot Topics

Top