VBA to search for a file, then change the name, change file type and save to new location

[AmandaKV]

HELP! Thanks to this and several other forums I am starting to really LOVE all the things VBA can do. Unfortunately I've hit a road block. I have an input form for my project leaders to input project information. This input form saves new data to the next open row in a table which then assigns it a number. The input form has an "update existing information" button that uses the assigned project number to pull information back into the input form, edit it and update the existing info in the table. I have multiple reports and forms built off the data table that all use the project number to generate reports.

Now for my request... I would like to have command buttons for project leaders to select a picture file from their files - once selected it renames the file LINKING IT to the assigned project number (example "43 image 1") - changing it to a .JPG - and saving it to a specific file in a SharePoint site.

I will then need another command box that, based on the project number entered, will download that picture into the report.


Phewwww when I type it all out I realize what a daunting task I'm asking for help on... But I have had so much luck getting info from other threads I figure i'll start my own.

Any help will be appreciated!

Amanda

[Pepe Le Mokko]

Administrative note

Welcome to the forum

missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you