Hi All,
I have a scenario to convert excel to PDF , while I do that I need each sheet to fit in one page but instead one sheet splits in to 2 page in PDF? any idea how I can fit one page in PDF.
Hi All,
I have a scenario to convert excel to PDF , while I do that I need each sheet to fit in one page but instead one sheet splits in to 2 page in PDF? any idea how I can fit one page in PDF.
Hi @SATHIYA_SEELAN,
ActiveSheet.PageSetup.PrintArea = ActiveSheet.UsedRange.Address
This code sets the print area for the active sheet to the used range of the sheet, which should ensure that the sheet fits onto one page when printed.
By using the “Invoke VBA” activity to run VBA code to set the print area for each sheet, you should be able to ensure that each sheet fits onto one page in the resulting PDF file.