The code below works with renaming workbooks, however it also moves them as well.
Is there a way to modify the code to make a copy of the workbook instead of moving it?
Thanks much in advance!
Sub RenameTesting()
Dim OldName1, NewName1
'Work books based on cell values below
OldName1 =...