I have no experience with VBA and very little programming experience in total. However, I know this can be done just not completely sure how. I'm looking for help or directions or resources on how to take a text file filed with information on part names and folder names and pack and go the files while renaming them. The folders are already created and properly structured.
An example of a file and its directory would be. C:\Vault\MRO02000-02999\MRO02875 MS201056702\MANUFACTURING INFORMATION\MRO02875-MS201056702-PROC.SLDDRW.
This file and the files which it is dependent which are other drawings and parts which have been inserted on after the other. So MRO02875-MS201056702-OP1 has been inserted into MRO02875-MS201056702-OP2 which has been inserted into MRO02875-MS201056702-OP3 which has been inserted into MRO02875-MS201056702-PROC and all of them have drawings. There can be up to 4 OPs and can or can't have a PROC.
I want to take all of those files and move and rename them to C:\Vault\AS3000-3999\AS3182 201056702\MANUFACTURING INFORMATION. My text file with all the information is structured as such:
MS201056702 MRO02875 2875 201056702 AS3182
I'm unsure how to load a text file into VBA and run loops again I have no experience. Also all the actions which I want to take place can be manually done with pack and go by checking include drawings and replacing save to name.
I have the example pack and go code which I'm trying to understand but I lack the resources and knowledge. Any help would be greatly appreciated.