File Name and Path refer to cells

[VBE313]

Is there a way to change the path name depending on what the user types in? I know you can do that with the file name.

 

[Yongle]

Yes there is but you need to explain a bit more ...

Which bit of the path can the user influence?
- subfolder only
- something else? what?

Is the user selecting from a dropdown (safe) or typing in freehand (fraught with danger)?

Does the folder ALWAYS already exist (safe) or is the user requiring the folder to be created on the fly(additional checks required in the VBA)?