My issue is that I have a bunch of workbooks that all have queries that need to be refreshed but I would like to create a method to do that automatically rather than having to open each one, refresh it, save it and close it. All of the workbooks have the same layout and the query I am trying to refresh is the same for each workbook. The query is pulling an inventory list from a master inventory file. All of the workbooks reside in sub folders specific for the week they were created and those sub folders are nested in another folder. I would love some suggestions for potential solutions to my problem. I have uploaded a blank version of the workbook I am trying to refresh. Thanks!
