Excel Macro Class

Microsoft Excel has a broad choice of dialogs available (file dialogs, color and formatting dialogs, etc.). In this post we see how to launc...

In this post we see how to export data in Excel as PDF using VBA macros. The data can be a range or table in a worksheet, the whole workshee...

In this post we learn how to combine all the Excel files in a given folder using VBA macros. The macro triggers a dialog box to select a fol...

In this post we learn how to protect all selected workbooks in Excel using VBA macros. The macro protects the workbook structure and the con...

In this post we see how to compare two Excel workbooks with VBA macros. The macro checks if the number of worksheets matches, then compares ...

We often need to gather data spread across several Excel workbooks. The following VBA macro combines all open workbooks into just one. The f...

This macro example separates sheets into new workbooks, keeping the original workbook. Each new workbook takes the name of the sheet and con...

This is a simple example to copy the selected range into a newly created workbook. We use object variables to easily manage both workbooks. ...

Excel VBA generates and error if the file we try to open does not exist. It also display an alert and breaks the code if the file is already...

Excel allows to define names that can be used in formulas instead of cell references. This macro example lists all defined names and formula...