Move Files to Master Folder Based on the Contract no e.g T1782, T98882

[taimoor07]

Hi All. Any kind of help would be really appreciated. I have below VBA project which moves files from one folder to Master folder based on the specific identification number which is "T" and then numbers. For example. T98 Contract, T12984 Contract, T 92 Lease. below is the sample of file names,

T1525 FULLY SIGNED LEASE_9263pdf
T1525_FULLY SIGNED LEASE_9263pdf
T 1525 TEMP RENEWAL_8233pdf
eT920_Principal Lease Agreement_10542pdf
eT920_RENEWAL AGREEMENT_452TIF


The current code moves the file based on initial 13 character however i want to change it to move the files based on the contract number starting from T.

I think i need to only change the StrDestFolder Code. I tried to change the line to below but its not working.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[alansidman]

Code Tags Added
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

[Marc L]

Hi,

unclear …

Is it only for pdf files ? Should be easy with a good enough elaboration with samples as your files names are not consistent …
See also the samples in the below Similar Threads section.