Prompt user to locate a file to then be saved to predetermined directory

Hi all,
I have designed a series of data entry Userforms, one of which requires the user to 'attach' a photograph. I have got as far as creating a button that prompts a Application.GetFilename which then pastes the selected files path into a textbox.

I was wondering if there is a way to take this a step further and instead of only extracting the file path, it is possible to also take the selected file and copy it into a predetermined directory of my choice.

Any help or tips would be greatly appreciated.

Thanks!

Thanks for the reply.

I am currently at this stage:

Please Login or Register  to view this content.

How would I go about using the selected file location (a) in the FileCopy line you suggested above?

Please Login or Register  to view this content.

This is perfect. Thank you.

I have tweaked it slightly so that the user is not required to select a destination folder. Additionally I would ideally like the selected file name to be changed to a cell value.

Please Login or Register  to view this content.

The example above uses cell "B4" of sheet "New Sign" as the file name. Is it possible to name the file by finding the next available (blank) cell in column "B" and instead using the value of column "A" in that row?

I seem to have resolved the issue I was having for naming the file by using a different cell reference.

The line you mentioned above pastes the new destination value into a txtbox within the userform. This path is later added to a worksheet. The reason I have done this is so that the image can easily be hotlinked to the relevant line in the dataset when it is viewed spatially.

Thanks for your help.