How to close all workbooks in Excel with VBA

How to close all workbooks in Excel with VBA

If you are working with multiple Excel files at once, you often find yourself dealing with warning messages when trying to close them. Although it is a good thing to be warned about saving to not lose changes in a workbook, it may become annoying quickly. Thanks to...
How to save each sheet as CSV in Excel

How to save each sheet as CSV in Excel

In this guide, we’re going to show you how to save each sheet as CSV in Excel. Download Workbook Excel to CSV Saving an Excel worksheet as a CSV file is an easy task. All you need to do is to use Save As section in File menu and select the CSV as the file type. This...
How to extract date from string in Excel

How to extract date from string in Excel

In this guide, we’re going to show you how to extract date from string in Excel by using formulas and VBA. Download Macro-Free Workbook Download Workbook Note that, there isn't a single formula or approach that can handle all scenarios. Extracting dates from strings...
How to spell check using VBA in Excel

How to spell check using VBA in Excel

Excel can spell check, but it's not as capable as the spell check in Word, nor is it automatic. Using VBA, you can automate the spell-checking process in your workbooks. In this guide, we’re going to show you how to spell check using VBA in Excel. Download Workbook...
How to show a message on Status Bar in Excel

How to show a message on Status Bar in Excel

In this guide, we’re going to show you how to show a message on Status Bar in Excel. Download Workbook What is Status Bar? The status bar is the bottom section of the application window (like in some other Windows applications). It displays additional information...
How to show a closing message in Excel

How to show a closing message in Excel

In this guide, we’re going to show you how to show a closing message in Excel by using macros. Download Workbook ThisWorkbook object and Workbook_BeforeClose Event If you want to trigger any action at the before closing of your workbook, you must add your code under...