pliskers
Active Member
- Joined
- Sep 26, 2002
- Messages
- 461
- Office Version
- 2016
- Platform
- Windows
I need some code that will reside in a Master file where data ranges in each file within a directory needs to be copied to.
Simply stated, the loop code will open every file in a single directory and, one at a time, will copy/paste to the Master.
I can handle the code to do the copying/pasting. What I need is the loop code to go through all of the Excel files in the directory and stop when the process has been performed on the last file.
Been searching the web, but am getting errors when I try to run the code that I've found so far.
I'm running Excel 2007, FYI. Thanks in advance!
Simply stated, the loop code will open every file in a single directory and, one at a time, will copy/paste to the Master.
I can handle the code to do the copying/pasting. What I need is the loop code to go through all of the Excel files in the directory and stop when the process has been performed on the last file.
Been searching the web, but am getting errors when I try to run the code that I've found so far.
I'm running Excel 2007, FYI. Thanks in advance!