Programming in Excel Lesson 5 - Workbooks and Sheets

This video tutorial will show you the following: 1. How to copy from one workbook to another workbook in VBA 2. How to copy from one worksheet to another worksheet in VBA 3. How to close a workbook in VBA 4. How to open a workbook in VBA 5. How to open a .xls file in VBA 6. How to open a .xlsm file in VBA 7. How to open a .xlsx file in VBA 8. How to open a csv file in VBA 9. How to close a workbook without saving changes in VBA 10. How to close a workbook and save changes in VBA 11. How to create a new worksheet after the last worksheet in VBA