Actions with Workbooks (no user input)

In this lesson we cover:

• How to create a new workbook
• How to close a workbook
• How to open a workbook
• How to save a workbook
• How to use SaveAs to change the filename
• How to activate a workbook

Bonus: Download and open the Module 6 Workbook called "Module 6 Lessons" and you will find a VBA code module called "Globals". This shows you how to create a subroutine that opens up the VBA Editor to a specific subroutine. This macro can be assigned to buttons a worksheet (like you see in the first 30 seconds of the video).

Write your comments and feedback below

• If you have questions or comments about this lesson, write it in the section below.
• Alternatively you can email the instructor Victor at [email protected]