I am experimenting with macros.........
I use the following macro to open the Word Template Dialog.

Sub AutoExec()
'
' AutoExec Macro to open the template Dialogue Box
' Macro created 25/02/2006 by Dermot Hayes
'
Dialogs(wdDialogFileNew).Show

End Sub

Question 1
Can anyone tell me the appropriate code to open the Excel Template Dialog?

Question 2
Where will I get a list of Excel command as they are used within code...i.e
wdDialogFileNew as use in the Word example above?

Question 3
Any general advice / links regarding useful Excel macros to consider
incorporating in excel spreadsheets?