topic Re: Print Excel sheet into PDF in SAS Programming

Print Excel sheet into PDF

hhchenfx — Thu, 08 Jul 2021 16:10:58 GMT

Hi Everyone,

I have an invoice in Excel sheet with graphic and table.

I wonder if SAS can help to print that Excel page into PDF.

The outcome is just like we use Save As PDF in Excel.

Thanks,

HHC

Re: Print Excel sheet into PDF

PaigeMiller — Thu, 08 Jul 2021 16:20:55 GMT

Why use SAS here? Excel can save as PDF.

Re: Print Excel sheet into PDF

Reeza — Thu, 08 Jul 2021 16:33:28 GMT

I would recommend using ODS PDF if you can...if you cannot, use VBS.

https://gist.github.com/statgeek/c51f58a009f8d315a200f34912e494b1

Change this line
mybook.SaveAs ""&default.\"" & Filename & "".xlsx"", 51";

to

mybook.SaveAs ""&default.\"" & Filename & "".pdf"", 51";

You'll need to figure out what that 51 should be - I can't seem to find it easily but it's out there somewhere.
It's not listed here which is where I'd usually find it, but I'm fairly certain I've done this before. https://docs.microsoft.com/en-us/office/vba/api/excel.xlfileformat