I currently have to run a report for each facility in our company and for each time running the report it prompts a date range and the 2 or 3 digit facility code. I then have to export them as a pdf and rename and save them. I am curious as to if its possible to code a macro to where I could input the date range once and have it step through all 140 ish facilities and run the report for each of them and save them in a folder while naming them using their corresponding facility code. I can make a new table lining up each facility with its code for the macro to reference if needed for the naming part. Mainly asking to see if its possible and worth investing time into as I have minimal knowledge of VBA code in general (especially in regards to access) and have only lightly used it in excel. {While looking through the possible duplicates I did see one or 2 questions that were close but an answer specific to this would still be helpful as one mentioned SSRS and/or running reports from a server and that doesnt seem to apply}