VBA to Print from Excel 2010 to pdf to a given path with a given filename.
Posted on 2014-04-02
I have an Excel 2010 workbook with 9 worksheets.
7 of the worksheets each contains a report in a named range on it.
I want to print these reports either individually or preferrably together in one pdf and then save to a given directory using VBA. Before creating any pdf I will use VBA to assign a unique name to it.
I normally use PDFCreator for printing to pdf format, but I will use whatever can do my task well.
Do you have a solution please.