I have a template that pulls in data from 37 other workbooks each week and calculates info with charts. My macro does not close all of the 37 workbooks automatically b/c each book prompts for "save changes? etc". Its not a big deal to click no 37 times real quick, but I would like my macro to close them all for me. Is there an easy way to write this in a loop so I dont have to hard code this for all 37 book file names?