» Close a workbook using VBA in Microsoft Excel
VBA macro tip contributed by Erlandsen Data Consulting offering Microsoft Excel Application development, template customization, support and training solutions
CATEGORY - Files, Workbook, and Worksheets in VBA
VERSION - All Microsoft Excel Versions
If you just want to close a workbook without the user being prompted for any confirmations about saving the workbook you can simply do this :
ActiveWorkbook.Close False ' closes the active workbook without saving any changes ActiveWorkbook.Close True ' closes the active workbook and saves any changes ActiveWorkbook.Close ' closes the active workbook and lets the user decide if ' changes are to be saved or not
Book Store:
Recommended Books:
- The 11 Immutable Laws of Internet Branding
- Excel 2002 For Dummies®
- Writing Excel Macros with VBA, 2nd Edition
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- The Ernst & Young Business Plan Guide
- Microsoft Windows XP Step by Step (With CD-ROM)
No comments have been submitted.
