Hello Everyone,

I'm using the following code to create a folder based on a created cell value as entries are added,

For Each cell In Selection
        MkDir "C:\" & ActiveCell.Value
I'd like to:
1. copy and paste 3 word documents to this new folder from another non-changing folder
2. open the newly created folder.

The bonus point question..
3. Can the file be renamed to reflect the newly made directory? Something like, xyz.doc -->xyz_"folder name".doc The created folder is a number named folder. Appending the newly copy and pasted files with the activecell would work as well.

I hope I made sense.

thanks in advance