RudySchneider
New Member
- Joined
- Oct 21, 2015
- Messages
- 7
I tried to be as descriptive as possible with that title, and there may already exist a post that would help me, but...
1. I have a spreadsheet with many rows of wire harness numbers.
2. Going into Windows Explorer, I can navigate to a top-level directory and search for all the (Visio) files that contain that harness number.
3. I can then manually enter the file name(s) (or file number(s)) into a cell to the right of the harness of interest.
4. Repeat for next row (harness number).
Yeah, that works fine, but I've got a whole lotta harnesses for which I must search. Yes, I am capable of eventually writing my own VBA or macro to automate the above process, but with all the talent here, I'm hoping someone has had a similar challenge that he/she has already mastered, or a related post to which someone can direct me.
Thanks in advance --- Rudy
1. I have a spreadsheet with many rows of wire harness numbers.
2. Going into Windows Explorer, I can navigate to a top-level directory and search for all the (Visio) files that contain that harness number.
3. I can then manually enter the file name(s) (or file number(s)) into a cell to the right of the harness of interest.
4. Repeat for next row (harness number).
Yeah, that works fine, but I've got a whole lotta harnesses for which I must search. Yes, I am capable of eventually writing my own VBA or macro to automate the above process, but with all the talent here, I'm hoping someone has had a similar challenge that he/she has already mastered, or a related post to which someone can direct me.
Thanks in advance --- Rudy