I'd like to pull data from another workbook. I'd like to open the folder that's named in A2. The user would then find the workbook and open it. I can populate the code for copying, but then i would want the workbook to close. Is opening and closing the workbook the quickest way to pull data?