Greetings everyone. Does anyone know how to help me out with this if at all possible. I want to search for files in a specific folder, find any newly created or updated files, then convert the newly created files to a pdf, merge the newly updated files to another file (with similar name), and finally update a spreadsheet I am using a database with a hyperlink to the new files created.
The spreadsheet that I want to update (attached) is what the users use to see the files. I have userforms that contain the names of the files. I want to add any newly created files to the list on this sheet. This would involve adding a hyperlink to the file location. It would also be a plus if there was someway to pull the information such as part number, description, etc off of the file and add to the database form but I can save that for another question. Right now, i am concerned only with creating/updating the hyperlink to the file location. There should be no need to change any of the files that were recently updated since their name and hyperlink should already be on the spreadsheet. Is there a better way to do this? If so, I am open to suggestions. Thanks everyone!