Generate File path that has been created from another macro to Cell

[dave1983]

Good Morning

I have the following Macro that someone helped me with, It was moving some files over to the end location but now it doesnt seem to be doing that, What I wanted to do is write the final folder path to Cell F2 once it has run through the macro.

Please Login or Register  to view this content.

I then have this Macro set up to move the files

Please Login or Register  to view this content.

I will change this line

Please Login or Register  to view this content.

To point to the cell with the final path string in it

Please Login or Register  to view this content.

I assume that will work?

[TonyS]

Change
Const strDestinationPath As String = "Sheets("Move & Rename").Range("F2").Value" to

Please Login or Register  to view this content.

[dave1983]

Thanks for that, all I need to do now is have the path string from the macro below be filled into cell F2.

Anyone know how this can be added to the macro

Please Login or Register  to view this content.

[dave1983]

Bump!!!!!!!!

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[dave1983]

I actually added the line of code you suggested into my existing macro and it has done the required job, here is the new macro just incase any one needs it for reference

Please Login or Register  to view this content.