Create Excel VBA script to rename PO pdfs from csv -- 2

Need to write some vb code for repeat task **Requires renaming of pdf files.** Two simple scripts required, since user intervention needed in between MUST provide all source code unlocked. All files will occur within same folder (no subfolders) so no file-paths should be necessary. First script: On open, read in .csv file -current pdf name is in column J, new pdf name is in column S (requires some simple cleaning) -put names into input and output columns respectively End first script At this point the folder and files would all look like the 'before' folder provided. User will check output names, may need to correct on occasion. Second script: Upon user manually run query (or click button) Rename files based on input and output names. Clear CSV contents. Clear input and output for next run. Display success box to user. End Second script. At this point the folder and files would all look like the 'after' folder provided.