I'm trying to automate the process to convert reports generated by an Excel
macro to PDF files (one report has to be saved as a PDF file, then the macro
will clean up the Excelsheet and create another report, save the new one as
another PDF file. Excel should continue the procedure until the macro tells
Excel to stop).

Any suggestion will be highly appreciated.