hello,
i have a folder containing many(and many more to come) .xlsx (2007) files that are linked to other files in another folder. all i want is a macro that opens each file (so they can update), save them, and then close them again. at first i tried to record a macro and just go through those actions. i got as far as opening them and each file was listed in the vba code which made it very long. since i will be adding files from time to time i figured that would be way too much work to add each file individually to the code, im thinking there has to be a better way.


thanks for the help
hart