Hi,
I am new to Excel VBA and am still on the learning curve, hopefully one of you can help!
I am trying to form a loop that will run through a list of excel files that I have hard coded in column C. They need to open up one at a time, run the macro in that file, copy data on one of the sheets, paste it in my master workbook, close out, and then open up the next and do the same thing. The files are all in separate folders as well which makes it tougher. Also I plan on adding new file names to column C in the future.
The part I am really struggling to get my head around is how I can open up the excel files that I have hard coded in column C one at a time. Once I can pull them up I'm sure I can figure out the rest.
I have done some extensive googling but there is not much on this type of loop, from what I have found.
Thanks!
I am new to Excel VBA and am still on the learning curve, hopefully one of you can help!
I am trying to form a loop that will run through a list of excel files that I have hard coded in column C. They need to open up one at a time, run the macro in that file, copy data on one of the sheets, paste it in my master workbook, close out, and then open up the next and do the same thing. The files are all in separate folders as well which makes it tougher. Also I plan on adding new file names to column C in the future.
The part I am really struggling to get my head around is how I can open up the excel files that I have hard coded in column C one at a time. Once I can pull them up I'm sure I can figure out the rest.
I have done some extensive googling but there is not much on this type of loop, from what I have found.
Thanks!