New Workbook based on Template

[maxhugen]

Is there any way that I can create a shortcut that opens a new workbook
based on a template.

In MS word, a command line switch is provided to do just that, eg:

winword.exe /t"H:\Templates\Alpha Financial\Letter.dot"

MTIA

 

[Dave Peterson]

Maybe you can use a helper workbook.

Your shortcut would look like:

excel "C:\my documents\excel\book1.xls"

But inside book1.xls, you'd have an auto_open macro that looked like:

Option Explicit
Sub auto_open()
Workbooks.Add template:="H:\Templates\Alpha Financial\workbook.xlt"
ThisWorkbook.Close savechanges:=False
End Sub

 

[William Hamilton]

Is there any way that I can create a shortcut that opens a new workbook,
based on a template.

In MS word, a command line switch is provided to do just that, eg:

winword.exe /t"H:\Templates\Alpha Financial\Letter.dot"

MTIA!

How about just having the template name as the command line (shortcut),
if the associations are correct it should work ok.

W

 

[Dave Peterson]

Doh!

How about just having the template name as the command line (shortcut),
if the associations are correct it should work ok.

W

 

[maxhugen]

Hi William, Dave

Yes, the shortcut worked just fine! For some reason that didn't mak
sense to me so I didn't even try it!

I was thinking I might have to do just what you suggested, Dave, bu
there you go - such a simple solution!

Many thanks for your help!

Cheers From Downunder