Is there any way to automate opening an Excel file and then saving it as a PDF? I am not creating the Excel file in automation, just updating a table that the Excel file uses for a pivot.
Actually, no. We support refreshing an Excel file with pivot table (output is xlxs) or we support using Toad Pivot Grid and exporting to PDF. So to get a pdf of a pivot grid you woul need to use our Toad Pivot Grid.