Outlook VBA PDF Renamer
Budget: $10 – $30 CAD
First test box- to enter file number for example – 4011
Create button should create a folder with text box number in a specific location.
Search button should search the file folder
C:\FILES\1000-5000C:\FILES\1000-5000\4001-4050\4011
Search all the sub folders and find all PDF files which has amendment in their names,
And list those files.
Lets take that folder has 5 pdf files which have “amendment” in their names, and also “agreement”
The below should be listed in list box.
4011-Amendment 1
Amendment 2 – 4011
Amendment 3 to agreement 4011
Amendment 4
Amendment 5
In the second text box user enters a number- for example “1”
Now the user selects first file and click “save as” button,
The Save as button should create a copy of the file and “Rename” and save as the first file with a name “Amendment 1 to Agreement No. 4011 (take this file no from text box 1).
When user selects second file and enters number “2” in second text box and create. Second file needs to be saved as Amendment 2 to Agreement No. 4011 (take this file no from text box 1) in the same folder which was created with name “Rename”.
Create button should create a folder with text box number in a specific location.
Search button should search the file folder
C:\FILES\1000-5000C:\FILES\1000-5000\4001-4050\4011
Search all the sub folders and find all PDF files which has amendment in their names,
And list those files.
Lets take that folder has 5 pdf files which have “amendment” in their names, and also “agreement”
The below should be listed in list box.
4011-Amendment 1
Amendment 2 – 4011
Amendment 3 to agreement 4011
Amendment 4
Amendment 5
In the second text box user enters a number- for example “1”
Now the user selects first file and click “save as” button,
The Save as button should create a copy of the file and “Rename” and save as the first file with a name “Amendment 1 to Agreement No. 4011 (take this file no from text box 1).
When user selects second file and enters number “2” in second text box and create. Second file needs to be saved as Amendment 2 to Agreement No. 4011 (take this file no from text box 1) in the same folder which was created with name “Rename”.