Create a Macro to Update Named Ranges

I am trying to develop a Macro to open all .xls files in a certain directory and change about 30 (single cell) named ranges within each file. The named ranges are the same in each file, however they could be in different cells in the files.

If anyone has any insight, I would apppreciate it.

One way that i can think of is - in your macro file, have a list of all the 30 files with their respective named ranges and their cell addresses (or range addresses) and have the code to loop through each file and each named range & its address. Gonna be complicated but i guess it can be done.