New Workbook based on Template

M

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
 
D

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
 
W

William Hamilton

maxhugen said:
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!
Click to expand...

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

W
 
M

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
 
Top