jess98
05-25-2023, 07:57 AM
Hello everyone,
I'm wanting to use VBA to save some time in moving some files around. Basically, I have a list of word documents that are datasheets that are formatted as an an equipment piece name following a unique number, ie.
13-215.1 - Pump, Syringe 123456.docx. Id like to move these documents into their respective folders with the "UNIQUEIDENTIFIER - EQUIPMENT NAME" folder ie. 13-215.1 - Pump, Syringe folder. So I have already created all the folder names and the issue is the folder names are not always exactly matching the folder names, but the unique identifiers are, so id like to move the documents to the folders based on their number code.
So:
ME-102 - Cabinet, Biosafety, 6 ft 234567.docx ids moved to ME-102 - Cabinet, Biosafety, 6 ft folder
18-430.1 - Imaging Device, X-Ray Unit, Rad, Digital -TRANSFER.docx is moved to 18-430.1 - Imaging Device, X-Ray Unit, Rad, Digital folder
**notice that the documents names include numbers/notes that are not included in the folder name**
So my thought is that maybe we can move document to folder with when the first 8 characters of the folder name and the document name are matching? Anyone worked on something like this before?
Thank you in advance for any help - this would save me a looooot of time :)
I'm wanting to use VBA to save some time in moving some files around. Basically, I have a list of word documents that are datasheets that are formatted as an an equipment piece name following a unique number, ie.
13-215.1 - Pump, Syringe 123456.docx. Id like to move these documents into their respective folders with the "UNIQUEIDENTIFIER - EQUIPMENT NAME" folder ie. 13-215.1 - Pump, Syringe folder. So I have already created all the folder names and the issue is the folder names are not always exactly matching the folder names, but the unique identifiers are, so id like to move the documents to the folders based on their number code.
So:
ME-102 - Cabinet, Biosafety, 6 ft 234567.docx ids moved to ME-102 - Cabinet, Biosafety, 6 ft folder
18-430.1 - Imaging Device, X-Ray Unit, Rad, Digital -TRANSFER.docx is moved to 18-430.1 - Imaging Device, X-Ray Unit, Rad, Digital folder
**notice that the documents names include numbers/notes that are not included in the folder name**
So my thought is that maybe we can move document to folder with when the first 8 characters of the folder name and the document name are matching? Anyone worked on something like this before?
Thank you in advance for any help - this would save me a looooot of time :)