| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoExec Code to Open Template Dialogue on Startup
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| When i open excel on the start dialogue, it does not open. | Setting up and Configuration of Excel | |||
| Excel/Word startup: 'Compile error in hidden module: AutoExec' ?? | Excel Discussion (Misc queries) | |||
| How do you open a template at startup? | Excel Discussion (Misc queries) | |||
| Need VBA code for "Open Dialogue" box | Excel Discussion (Misc queries) | |||
| Excel template-run code on open | Excel Programming | |||
Threaded Mode
