Dear Peterrc

Many thanks, this is extremely close to what I want. Only problem is this macro is making just 1 pdf of the report that is already selected.
what I want is, regardless of what report is selected, the macro should start making separate pdfs from first report to last (all pdfs stored in same folder).

* the macro picked the correct name by the way

Best regards
Mohammed Haziq