Want to know how to automate repetitive and boring tasks? Try out Microsoft Excel VBA Macro. In this article, we explain the advantages of using VBA Macro.

How to write VBA code If you want to learn Visual Basic for Applications, start with our guide to creating Excel macros.

This book provides Excel power-users, as well as programmers who are unfamiliar with the Excel object model, with a solid introduction to writing Visual Basic for Applications (VBA) macros and ...

When creating .NET class libraries, name them anything you like. To reference them in VBA, use the name of the .NET class library as shown in the previous example.

Access the Developer tab in Excel to write and run VBA code. Create a new VBA module to house your automation code. The PageSetup object is essential for customizing headers and footers.