Excel 2007 - Multiple sheets to PDF

[Jan Erik]

Hello,

I'm making av procedure which shall print multiple sheets to PDF:

ActiveWorkbook.ExportAsFixedFormat Type:=pFiletype, Filename:=pReport_FileFolder, _
Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
:=False, OpenAfterPublish:=False

The problem is that I want to change the sheets order into the PDF. For example Sheet2 = Page 1, Sheet3 = Page 2 and Sheet1 = Page 3 and so on.

Is there anyone who has a solution on this?

Regards
Jan Erik