New...

Home Search Site Map

Up
Close
Exit
File Search...
Most Frequently Used
New...
Open...
Page Setup...
Permission
Print...
Print Area
Print Preview
Properties
Save
Save As...
Save as Web Page...
Save Workspace...
Send To
Web Page Preview

New! Excel User Group Now Open @ www.excelusergroup.org,

Menu command Type What happens next?
New... ...

Presents the templates dialog

or in latter versions of XL (XP up), presents the 'New File' Task Pane which can then either open a blank workbook, templates on your computer or templates at Office Online.

VBA Sub wbNew()
Dim wb As Workbook
Set wb = Workbooks.Add
'Do what you want with workbook here using wb variable
End Sub

 

Top

Copyright Nick Hodge 2009. All Rights Reserved.