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 - [ Ссылка ]
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? - [ Ссылка ]
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;
[ Ссылка ]
*** Online Excel Courses ***
The Ultimate Excel Course – Learn Everything ► [ Ссылка ]
Excel VBA for Beginners ► [ Ссылка ]
Advanced Excel Tricks ► [ Ссылка ]
Excel Formulas Made Easy ► [ Ссылка ]
Creating Sports League Tables and Tournaments in Excel ► [ Ссылка ]
Connect with us!
LinkedIn ► [ Ссылка ]
Instagram ► [ Ссылка ]
Twitter ► [ Ссылка ]
Excel VBA: Opening, Saving and Closing Workbooks with VBA
Теги
excel vba - open and close workbookexcel vba tutorial for beginnersexcel vbacomputergagavisual basic for applicationsexcel vba basicsexcel vba copy paste range another worksheetexcel vba open and close workbookexcel vba open workbookexcel vba open workbook and copy dataexcel vba open another workbookexcel vba save and close workbookexcel vba save active workbookexcel vba copy paste range another workbookexcel vba tutorial
