topic Convert Excel to PDF with pagesetup options in Product Forum

Convert Excel to PDF with pagesetup options

Frederic_Hubin — Tue, 21 Nov 2023 16:04:00 GMT

Hey guys

I'm trying to convert excel file to pdf with specific page setup options (orientation and scaling).

I use this code, but it converts to pdf without paying attention to the options.

Dim wb as Object = GetWorkbook(handle, workbookname)

Dim excel as Object = wb.Application

Dim xlTypePDF As Integer = 0

excel.DisplayAlerts = False

wb.ActiveSheet.ExportAsFixedFormat (xlTypePDF, filename)

With wb.ActiveSheet.PageSetup

.Orientation = 2

.Zoom = False

.FitToPagesWide = 1

End With

excel.DisplayAlerts = True

Any idea?

Thanks a lot

------------------------------
Frédéric Hubin
------------------------------

abhis3kh — Wed, 22 Nov 2023 18:57:00 GMT

Try setting the page setup options before exporting to PDF. Let me know if that works for you.

------------------------------
Abhisekh Mukherjee
------------------------------

Frederic_Hubin — Thu, 23 Nov 2023 08:40:00 GMT

Thanks for your help here. It works for me.

------------------------------
Frédéric Hubin
------------------------------