Hello, I have lets say 5 filepaths in J1 to J5. I would like a VBA code that firstly opens a file based on that file path printed in J1 then copies b1 to a1 in that workbook, saves it and closes it. Then repeats for J2 file path and so on and so forth. Thank you in advance!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Open another workbook, make an edit, save and close that workbook - Loop this with multiple books
Similar threads
- Question
- Question
