Visual Basic for Applications allows you to automate other Office Applications directly from Excel.
After all, a particular process may involve applications other than Excel. However, in certain circumstances, you might have to (or want to) work with other applications from Excel. Examples of such activities are saving or opening an Excel workbook, saving an Excel file as PDF, finding the last row, copying and pasting or deleting blank rows. Several VBA tutorials within Power Spreadsheets explain how to carry out certain activities within Excel.
