Hi Friends
I have this code to convert Excel to PDF. I am selecting specific tabs from a larger workbook to create a number of different reports.
I want to be able to select certain tabs in specific order. But when creating the PDF it converts the tabs in the order they are found in the workbook. (Sheet1 -2 -3 -4 -5). Where i want as below
Sheets(Array("Sheet5", "Sheet2", "Sheet4", "Sheet3","Sheet1")).Select
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"C:\Users\glenn.durand\Desktop\Reports\Filename.pdf" _
, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
:=False, OpenAfterPublish:=False
Any ideas?
Thanks
I have this code to convert Excel to PDF. I am selecting specific tabs from a larger workbook to create a number of different reports.
I want to be able to select certain tabs in specific order. But when creating the PDF it converts the tabs in the order they are found in the workbook. (Sheet1 -2 -3 -4 -5). Where i want as below
Sheets(Array("Sheet5", "Sheet2", "Sheet4", "Sheet3","Sheet1")).Select
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"C:\Users\glenn.durand\Desktop\Reports\Filename.pdf" _
, Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
:=False, OpenAfterPublish:=False
Any ideas?
Thanks