This video illustrates how to Open One Excel Workbook and Copy the data from it to a Second Workbook in Excel VBA. This lesson also discusses the use of "Object Variables" and how to set them up in Excel VBA. Object Variables are when excel objects such as workbooks, worksheets, ranges, etc. are assigned to a variable in VBA code. This video also displays how to apply a filter to a range to data in VBA.
To get a copy of the files used in this video click the link below. NOTE: You may have the change the file names once downloaded to work with the code used in this video. Thank You!
theexcelcave.weebly.com/excel...