I provide clients with various reports and supporting documents. When I'm creating the reports, they have to be located in a specific folder ("Active files"). When I finish I tell the system to pull the files through to the client's server. After the client receives them, I move them to the folder "Completed files" under a subfolder named with the client ID. My report names all start with the client ID number and are the only MSWord docs in the file, the supporting documents are named according to the information therein and are all PDFs.
For example - say my client ID is LN1234. In "Active files" I would create a MSWord document named "LN1234 Report" and would then add several PDF docs. After it's sent to the client, I would create a subfolder named "LN1234" in the "Completed files" folder and move the report and supporting documents to that folder.
I'd like to be able to select the report and supporting documents in my active folder, then press a button that will use the client ID in the report name to create the subfolder in my completed files and move the documents to it.
Help?
