Open a new workbook from a template..

[basepointdesignz]

Hi,

I appreciate that this might be a simple fundamental question, but how can i create a new xls file from an xlt file (like using the File >> New inside the Excell itself)

I have this for starters..

Dim SchedulePath As String
SchedulePath = "X:/Templates/SheetSchedule.xlt"
Set SheetScheduleXL = XLApp.Workbooks.Open(SchedulePath)

...but i don't want to open the .xlt file, i want to open an .xls from it..

Sorry if this is Sesame Street VBA..



Cheers,

Paul
basepointdesignzltd..
XP Pro..
Pentium Core 2 Q6600 Quad Core
ASUS P5N-E SLI Motherboard
4GB DDR2 RAM
2 x SLI NVIDIA 8500GT SLi 1024MB DDR2 PCI-Express Graphics Cards

 

[SkipVought]

File > NEW

Turn on your macro recorder and have at it.

Skip,

_{Just traded in my old subtlety...
for a brand NUANCE!}

 

[firefytr]

Almost there, use Add instead of Open...

    Dim SchedulePath As String
    SchedulePath = "X:/Templates/SheetSchedule.xlt"
    Set SheetScheduleXL = XLApp.Workbooks.Add(SchedulePath)

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci