Create OrganizePdfFiles

This was a messy script I created to rename and move system generated pdf invoice copies from a local folder to another destination. The script copies the pdf text to a spreadshset and then gets the invoice number out of the cell where it was pasted. It's not pretty but was very useful for renaming thousands of pdf files automatically. 

Note the delay on line 59. I included this so I could do a cursory reveiw of each invoice. You may be able to exclude this but this is a slower macro.