OK novice here whos knowledge is limited to whatever I can scrape together from advice online so go easy ;-)

Looking to build something that will open each file in a given sharepoint location one at a time, run the macro in it (lets call it "Refresh"), save, close and only then move on to do the same with the next file in that same location until all are done.

Sure it should be simple but I'm struggling to find anything useful I can pull together to make it work.
Thanks