Hello all,
I typically move a number of files using VBA using very simple code (sometimes its FileCopy instead of NameAS):
Name Sheets(2).Range("F26").Value As Sheets(2).Range("F27").Value
The cells values that the code references typically look like this...