VBA to Name File Based on Text in Selected Cell

Question

VBA to Name File Based on Text in Selected Cell

Anonymous

I am trying to rename a newly-opened file based on the file name shown in a selected cell in the original file. The following code works well when the cell address is constant but I have not been able to get it to work based on a moving selection. Thanks in advance for your help.

Legend:

"w.Activate" is the original file where the proposed file names are indicated in different cells.

"wbNew" is the newly-opened file needing to be renamed (there will be hundreds).

w.Activate

wbNew.SaveAs Filename:=ActiveWorkbook.Sheets("External Data").Range("B14").Value, _

FileFormat:=xlNormal, Password:="", WriteResPassword:="", _

ReadOnlyRecommended:=False, CreateBackup:=False

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

7 answers

Answer 1

Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.