Toad World® Forums

Automate open Excel file and save as pdf


#1

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.


#2

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.

Debbie


#3

“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.”

i appreciate your suggestion …. Thanks Debbie.