Changing the path to rename files

[Elliot]

I have a code that renames files within a folder if the macro is in this.
I would like you to help me because I wanted the macro file was for example
on the desktop and asks in what folder I want to rename the files without having to put it on folder.
Thanks in advance.

 

[Marc L]

Hi,

see in VBA help Application.FileDialog(msoFileDialogFolderPicker) property …
​