Excel VBA - Open and Close Workbook

by Ben Thompson

 

In this video you will learn to open another workbook, make an update then save and close the workbook using Excel VBA.

We cover the basics, going through the script you need and explaining how it works. This simple yet powerful piece of Excel VBA will help you maintain multiple workbooks and automate repetitive and time consuming tasks.

See link below for more videos in our Excel VBA series!

Instructor Lead Excel Course ► https://essentialexceluk.com/products/master-excel-course

VBA Playlist ► https://essentialexceluk.com/blogs/tutorials/tagged/vba

More Tutorials ► https://essentialexceluk.com/blogs/tutorials

Access our COMPLETE Excel Course HERE

Back to Tutorials