Good morning,
I am using a VBA macro to export two worksheets as one PDF. The only issue with the code shown below is that because the sheet "take-off" is before "summ sht" in the workbook, the exported PDF also has them in that order. I would like "summ sht" to be page one in the PDF.
I tried to select the sheets in the order I want them to be, but it did not fix the problem.
Thanks
I am using a VBA macro to export two worksheets as one PDF. The only issue with the code shown below is that because the sheet "take-off" is before "summ sht" in the workbook, the exported PDF also has them in that order. I would like "summ sht" to be page one in the PDF.
I tried to select the sheets in the order I want them to be, but it did not fix the problem.
Code:
Sheets(Array("summ sht", "take-off")).Select
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"[URL="file://\\mainserver\common\ben\Exports\"]\\mainserver\common\ben\Exports\[/URL]" & Sheets("Take-Off").Range("AY2") & " - " & Sheets("take-off").Range("D1") & ".pdf", Quality:= _
xlQualityStandard, includedocproperties:=False, ignoreprintareas:=False, _
openafterpublish:=False
Thanks