I've been trying to figure out the best way to do this, but am getting confused!
So I have a workbook, and am looking for a piece of code which prompts the user to open files (csv) via explorer (i.e. manually clicking). The files will be in the same folder, so the user will then select several files at once (between 1 and 10).
I wish to copy some columns from the first workbook that's been opened, and paste the range into the active workbook and then perform some operations on the data.
Then I wish to copy the same columns from the second workbook, and paste them into the active workbook.
I want to run through all the workbooks that have been opened repeating this.
Once all have been used, I want to close them all (without saving).
There may be other workbooks open at the start of this process, so their names must be recorded first so that they can be ruled out of the following operations, and remain opened after the process completes.
So, to sum up in one (long!) sentence:
I'm really just looking for the code that will prompt the user to select the files (in one operation) from a folder, store their names and then be able to cycle through them in order to copy the data I want, then close them.
I hope that makes sense & fingers crossed you can help!