Posts by MrSteves

    Based on Andy's response above I was able to re-purpose his code; goal being to pull old and new Control Names from a spreadsheet and update the Control Names in bulk. Posting in case anyone finds it useful.


    I had old and new names stored in a spreadsheet called "x_Controls": the old Control.Name in Column 2 and the new Control.Name in Column 3 (loop starts on Line 2 as header was in Line 1). Incidentally TypeOf is stored in Column 1 so Andy's "If Statements" could be worked into the logic also if needed.



    Updated a few hundred names with no problems!