Excel VBA: Opening, Saving and Closing Workbooks with VBA

In this video, we look at how to use workbooks in Excel VBA. We focus on opening, saving and closing workbooks and different techniques to do so. With their pros and cons. Enrol in the full Excel VBA for beginners course - http://bit.ly/2JvnnRv The scenario in the video is to copy and paste a range of cells from the current workbook to one that is saved on a drive somewhere. So we will need to open the other workbook, and then refer back to the previously current workbook to copy a range of values from it. Need help with a VBA project? - https://partners.excelrescue.net/74-3-3-1.html A few different techniques are covered by this scenario. A nice introduction to referencing the current or other workbooks with VBA. And why you would use specific approaches. Find more great free tutorials at; https://www.computergaga.com *** Online Excel Courses *** The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel Excel VBA for Beginners ► http://bit.ly/2JvnnRv Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2t3netw Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2viGg3J Connect with us! LinkedIn ► https://www.linkedin.com/company/18737946/ Instagram ► https://www.instagram.com/computergaga1/ Twitter ► http://www.twitter.com/computergaga1