Print Excel sheet into PDF

[hhchenfx]

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

[PaigeMiller]

Why use SAS here? Excel can save as PDF.

[Reeza · Accepted solution]

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