Excel 2010 macro save as pdf

Macro to Save as PDF - Using file

When I recorded this as a macro, Excel used Active Sheet when it successfully published the PDF. this is what i came up with as i was having issues with @asp8811 answer(maybe my own difficulties) ' this will do the put the first 2 sheets in a pdf ' Note each ws should be controlled with page breaks for printing which is a bit fiddly ' this will explicitly put the pdf in the current dir Sub luxation2() Dim Filename As String Filename = "temp201" Dim sht Ary() Re Dim sht Ary(1) ' this is an array of length 2 For i = 1 To 2 sht Ary(i - 1) = Sheets(i).

Macro to create Excel data to PDF file.

The documentation I've found from Adobe and MS has been poor. When I tried the Active Sheet(s) option, I got what I wanted.

<i>Macro</i> to create <i>Excel</i> data to <i>PDF</i> file.

Macro for Save As PDF Excel 2010

Your solution is much better for using multiple sheets. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count). Export As Fixed Format Type:=xl Type PDF, Filename:= _ "C:\Users\James\Desktop\pdfmaker.pdf", Quality:=xl Quality Standard, _ Include Doc Properties:=True, Ignore Print Areas:=False, Open After Publish:= _ True End Sub Security that notes whether or not it allows Reader to sign... Would you like to answer one of these unanswered questions instead?

Macro to Save File as PDF based on

Is there anyway to save you entire workbook as a pdf in excel. Excel; //Excel Reference //Gets Excel and gets Activeworkbook and worksheet Excel. Export As Fixed Format Type:=xl Type PDF, Filename:= _ "C:\Users\My Account\Desktop\test.pdf", Quality:=xl Quality Standard, _ Include Doc Properties:=True, Ignore Print Areas:=False, Open After Publish:= _ True` Russell Saari - to verify this simply open up excel and do this manually, you will see what happens.


Excel 2010 macro save as pdf:

Rating: 93 / 100

Overall: 88 Rates