I have a pretty tall order on my hands to copy certain text from word documents in a folder and past it into an excel document. Each folder could contain anywhere from 10 to 2500 word documents. Plus there are multiples of some documents and I only need the most recent one. For example I have 123456-A-1.doc, 123456-A-2.doc, 123456-B-1.doc. And I only need the information out of 123456-B-1.doc. As far as the information I need, I’ll attempt to show you what a document looks like.
Part Name : 123456-B
Material : Aluminum
Make Qty : 10
Program Notes: Load sheet left
Station Shape Orient Bin Notes
T3 RND 0 CAB Pgmr> Check clamps
T7 OBRND 0 CAB Pgrm>
T1 SQR 0 CAB Pgrm> Check orient
Sometimes there are no Program notes and as you can see sometimes there are no other notes next to Pgrm>. Also the stations can range from 3 to 30 depending on the document. I also need to extract the Rev from the part name and put it in a separate column. Here is my idea of what the excel document should look like.
PART_NUM REV PGRM_NOTES NOTES_1 NOTES_2 NOTES_3 NOTES_4 etc..
123456 B Load sheet left Check clamps Check Orient
the formatting is a little off but hopefully you get the gist of it
Am I asking for the impossible? Is a macro not the best solution to this problem?