New member here and only know enough VB to get errors, lol, so please bear with me. I am working with Excel 2013. Here’s my set up:
• My project involves over 200 book files to be reviewed, each has its own folder and follows a specific workflow.
• The book folders are uniquely-named, moved as the status changes, and may reside in one of six subfolders at any given time.
• An Excel file (called a traveler) resides in each book’s folder that contains the current status and workflow history of that book.
I have a master Excel file (MasterFile) that resides in the main folder and provides a status of ALL of the travelers (these travelers must remain closed). Currently, I have WS code accomplishing this. It works, but there are a ton of repeated external paths that I know would be much cleaner in VB. I figured the first task is to define all the path variations as strings and concatenate them, but I just can’t figure out how. After that, I will need to figure out what function in VB is comparable to VLOOKUP, so I can pull dates from the travelers based on the status. I’ve Googled it to death over several weeks. Every time I find where someone is answering a similar question, I get stuck trying to decipher which part of the suggested code is an actual VB function, and which is the variable.
Folder structure:
MAIN FOLDER
-MasterFile
-SUB1
-SUB2
-SUB3
-SUB4
-SUB5
-SUB6
Please include the entire SUB routine... yes, i'm that much of a newbie.
Thanks in advance for any help!
Bookmarks