This video is part 5 in a series for a beginner's guide to Excel VBA. This lesson covers dealing with Workbooks in VBA. The tutorial begins with how to Open a Workbook. The second part of the video covers how Copy data from one Workbook to Another as well as copying to a New Workbook. The end of the lesson deals with how to Save a Workbook to a certain path.
Learn More about Excel VBA & Macros with this Book on Amazon:
https://amzn.to/3xnqT6R
Get a Microsoft Office 365 Personal Subscription with this Amazon link:
https://amzn.to/3aV9GtL
DISCLAIMER: As an Amazon Affiliate I get a commission for every purchase via these links.
#ExcelVBAWorkbooks
#ExcelVBACopyWorkbook
#ExcelVBASaveWorkbookAs