Excel macros use Visual Basic code to perform functions unavailable through the program's graphical controls. For example, macros can extract data from a sheet, perform string operations on them ...

Excel offers myriad options for referring to workbooks and sheets in your VBA code. See which methods make sense in which situations.

Inserting a lot of columns or rows in Microsoft Excel is awkward and prone to mistakes. When you need to enter dozens or more columns, use this VBA procedure for ease and accuracy.

Excel can send alerts based on spreadsheet data, but you'll need to write a macro to do it. We'll show you how.

In Access, you can export data from Access in various formats such as Excel, Word, and SharePoint list. Exporting an Access database to Excel will export an object to a worksheet in an Excel file.