PDA

View Full Version : Save As PDF in a particular order



anne.gomes
06-25-2014, 03:08 PM
Hi,

So I want to save sheets in PDF as displayed in the array, it is in the same order in the workbook. But when my PDF gets produced it's in a completely different order than how I would like.

Can any one help?




graphTabList = Array( _
"BU Queue Analysis", _
"BU Aged Analysis WIP", _
"BU Respondants Analysis", _
"BU In Workflow Analysis", _
"BU Supplier Analysis" _
)

Sheets(graphTabList).Select
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _
fileName:="http://site/Reporting%20Documents/" _
& fileName & "\" & "AP Analysis for Today", Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=False



Ive already tried using Selection instead of ActiveSheet but it gives me an error

werafa
07-08-2014, 06:05 PM
I think you will need to review the print area setup.
I've not used vba to manipulate this, but have manually set print areas for a 'save to pdf' operated from a macro.
a study of print area vba properties might yield fruit for you

you may also be able to save and append to an existing PDF - some pdf writers do this.
Sorry I am not more use