From the course: Excel: Learning VBA

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Manage workbooks with VBA

Manage workbooks with VBA - Microsoft Excel Tutorial

From the course: Excel: Learning VBA

Start my 1-month free trial Buy for my team

Manage workbooks with VBA

“

- [Instructor] Just as you can add, delete and rename worksheets, you can do the same with your workbooks. You can also save them, either under the same name or a different one. In this movie I will show you how to perform those tasks using Excel VBA. My sample file is 05_08_Workbooks, and you can find it in the chapter five folder of the Exercise Files collection. This workbook does contain some data on its single worksheet, but I'm actually going to be working in Excel VBA with the workbook as a whole. So I'll press alt + F11 to move to the Visual Basic Editor, and I've already created a code module to work in. I'll call my code module Sub WBK Test, and that's just short for workbook test, it isn't anything that you have to remember. And open and close parenthesis. And then I will press enter and give myself a number of blank lines to work with. Let's say that I want to open a workbook. To do that, I will use the…

Contents