Convert mutiple ranges to one PDF document

[Access Beginner]

Hi,

I am attempting to convert multiple ranges from different sheets to one PDF document. I have recorded a macro so it convert 2 ranges from 2 different sheets, into 2 PDFs. But I do not know how to change this code to get both ranges into the 1 PDF document. Not sure if it can even be done. The company that I work for does not allow the purchasing of programs nor add-ins, that may accomplish this either.

Sub pdf_convert_test()
'
' pdf_convert_test Macro
'
'
    Sheets("Remoteness Sheet").Select
    Range("A3:V105").Select
    Selection.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
        "P:\Data\Customer populations\pdf test1.pdf", Quality:=xlQualityStandard _
        , IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:= _
        True
    Sheets("Area Data").Select
    Range("A3:S135").Select
    Selection.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
        "P:\Data\Customer populations\pdf test2.pdf", Quality:=xlQualityStandard _
        , IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:= _
        True
End Sub

Excel 2007

Cheers

 

[Access Beginner]

Any takers? Even if only to say it cant be done.

Cheers

 

[Peter_SSs]

Would this work for you?

1. Have an extra 'report' worksheet especially for this.
Then have your macro ..
2. Clear this 'report' sheet.
3. Copy each of the 3 ranges to the 'report' sheet.
4. Convert the 'report' sheet to a pdf.

 

[Access Beginner]

Would this work for you?

1. Have an extra 'report' worksheet especially for this.
Then have your macro ..
2. Clear this 'report' sheet.
3. Copy each of the 3 ranges to the 'report' sheet.
4. Convert the 'report' sheet to a pdf.

Sorry for the delay in responding.

Yes this works, thanks for the suggestion.