» Add and Save new Workbook using VBA in Microsoft Excel
CATEGORY - Files, Workbook, and Worksheets in VBA
VERSION - All Microsoft Excel Versions
Place the code below into the standard moduleSub AddSaveAsNewWorkbook() Dim Wk As Workbook Set Wk = Workbooks.Add Application.DisplayAlerts = False Wk.SaveAs Filename:="C:/MyData/SalesData.xls" End Sub
Book Store:
Recommended Books:
- East of Eden (Oprah's Book Club)
- Microsoft Excel Version 2002 Step by Step
- Finance and Accounting for Nonfinancial Managers
- Harry Potter and the Order of the Phoenix (Book 5)
- Financial Peace: Revisited
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
No comments have been submitted.
