VBA/Macro Course - 3 Ways to Create New Workbooks & Save and Close Them Using a Macro

View the Full VBA/Macro Course: https://www.teachexcel.com/vba-course-update.php
Downloadable File: Available in the full course.

How to create new workbooks using VBA and Macros in Excel and then the proper way to reference those new workbooks so you can do something with them, including saving them to a new file and closing them.

(New Non-VBA tutorials are coming soon, I promise!)

This tutorial specifically covers:
- How to export a worksheet into a new workbook using VBA.
- How to move a worksheet into its own workbook using VBA.
- How to create a new blank workbook using VBA.
- How to save new workbooks using VBA.
- How to close new workbooks using VBA.
- How to properly reference new workbooks using VBA.

This is a smaller version of the tutorial for my VBA course on TeachExcel.com and I hope you find it helpful :)

Excel Courses:
- VBA/Macro Course: https://www.teachexcel.com/vba-course-update.php
- Building Professional Forms: https://www.teachexcel.com/premium-courses/68/idiot-proof-forms-in-excel?src=youtube_v_jo6VYv9Loh8

TeachExcel.com

#msexcel #vba #tutorial

Видео VBA/Macro Course - 3 Ways to Create New Workbooks & Save and Close Them Using a Macro канала TeachExcel