Hi all,

I'm a beginner in excel macros and I am trying to write one which allows to select a file on the computer, to enter a new name and to copy it in a chosen folder.

To choose the file, I wanted to use Application.FindFile but I didn't find how to put the file into a variable, it only opens it...

I couldn't find any answer on internet so I definitively need some help...!

Thank you

Olivia