IF function
Description IF function returns one value if a condition you specify evaluates to TRUE, and another value if that condition evaluates to […]
Create a Backup of a Workbook with Current Date
We all know that making backups of your work is important. Now you can have a macro do it for you. This simple […]
Prevent the Workbook Closing If a Cell is Empty
Sometimes you may not want a user closing out a workbook without entering a specific piece of data. In these situations, you […]
Print All Workbooks in a Folder
Sometimes you may need to print all workbooks in a folder, open each workbook, print, close the workbook, and then open the […]
Open All Workbooks in a Folder
Sometimes you may need to go into your folder, open each workbook, edit, save it, close the workbook, and then open the […]
Save and Close All Workbooks at Once
Sometimes you may need to save and close many workbooks at once. For each workbook you have opened, you need to activate […]
Refresh All Data Connections on Workbook Open
Your workbook may have connections to external data sources such as web queries, MSQuery connections, PivotTable connections, and so on. In these […]
Determine If a File Exists in a Directory
Sometimes you may need to determine if a file exists in a directory. For instance, the purpose of your macro may be […]