Hello, I am looking for a macro that will find a file based on cell value and remane that file based on another cell value. I use the code below to locate the file I want to rename. I then want to rename that file based on value incell I19 of the same sheet listed below.
Code:
Workbooks.Open(Filename:=Worksheets("Mechanical").Range("I11").Value _
, UpdateLinks:=3)