I am having issues creating a macro which will open a report, print the report and then continue on to the next one. I have got it so it will open each report and print them but it is requesting the reference number for each report. The idea is that I will be able to open it, run the macro and enter the reference number to begin with and then have it carry over to the next one. Any help would be greatly appreciated.