ExportAsFixedFormat without Select

[amartinez988]

Hi,

I'm trying to export 3 Excel tabs as PDF. Everything works fine if I use>

    Sheets(Array("REPORTING", "REPORTING 2", "REPORTING 3")).Select
    Sheets("REPORTING").Activate
    ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, fileName:= _
        "C:\Users\user\Desktop\1905 Sport-Holdings Reporting Template Current.pdf" _
        , Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
        :=False, OpenAfterPublish:=False

But I don't really like using select in my code. So I was trying something like>

    Sheets(Array("REPORTING", "REPORTING 2", "REPORTING 3")).ExportAsFixedFormat Type:=xlTypePDF, fileName:= _
        "C:\Users\user\Desktop\1905 Sport-Holdings Reporting Template Current.pdf" _
        , Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
        :=False, OpenAfterPublish:=False

To avoid the Select and ActiveSheet code, but that throws an error. Is there any way to accomplish this unifying the 3 lines of code in one or for this case it really has to be this way?

Thanks

[dangelor]

You could use...

    With Sheets(Array("REPORTING", "REPORTING 2", "REPORTING 3"))
        Sheets("REPORTING").ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
        "C:\Users\user\Desktop\1905 Sport-Holdings Reporting Template Current.pdf" _
        , Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
        :=False, OpenAfterPublish:=False
    End With

[Fluff13]

@dangelor
That will only create a pdf of the Reporting sheet.

[dangelor]

@dangelor
That will only create a pdf of the Reporting sheet.

I stand corrected - I had 3 sheets manually selected before I ran the code.

[Fluff13]

Where they all selected when you ran the code?

[amartinez988]

Yes. I need to export all 3 sheet in one pdf document.

[Fluff13]

You can remove this line

Sheets("REPORTING").Activate

but I think that they need to be selected.

[Arkadi]

From all I've read, you do have to select the sheets you want to export.

[shg]

Ditto. I think it's somewhere between a failure of consistency and a bug.

[amartinez988]

Yes. I can't find any other way. Weird, usually that Select statement can be replaced by the action you want to do.

[Fluff13]

Unfortunately not with ExportAsFixedFormat.

Not sure about xl 2010, but with 2013 it seems to set the print area based off the active sheet, so the other sheets are not printed correctly.

[amartinez988]

Weird. Ok guy, thanks.

[Fluff13]

You're welcome & thanks for the feedback