Print to PDF vs. Create PDF

**JPSIMMON** · 07-04-2016, 03:24 PM

So I have been using the below code to print to PDF forever and it works well, however upon my last Adobe upgrade my PDF's turnout in negative colours and strange quality. IT has advised that I use the "Create PDF" function in Excel vs. "Saveas PDF" like my macro has. Does anyone know how to change my code to do this?

ThisWorkbook.Sheets(Array("Sheet1", "Sheet2", "Sheet3")).Select

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, FileName:= _
"s:\Location\Folder\MYSHEETS.pdf", Quality:=xlQualityStandard, IncludeDocProperties:=True, _
IgnorePrintAreas:=False, OpenAfterPublish:=False

Much appreciated,

**shg** · 07-04-2016, 03:46 PM

I installed the current versions of Acrobat a few months ago (Acrobat DC) and that code still works fine for me. To my knowledge, Create PDF is a UI thing (a button on the Acrobat tab).

Print to PDF vs. Create PDF

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Print to PDF vs. Create PDF

Re: Print to PDF vs. Create PDF

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] cell borders that I create dont show on print preview or print

[SOLVED] Create a print macro that would automatically select print area?

[SOLVED] Create a print macro that would automatically select print area?

[SOLVED] Create a print macro that would automatically select print area?

[SOLVED] Create a print macro that would automatically select print area?

Create a print macro that would automatically select print area?

Create a print macro that would automatically select print area?

[SOLVED] Create a print macro that would automatically select print area?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions