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
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