Is it possible to generate separate ranges onto the same pdf without Adobe Acrobat?

[Mescoman]

Hey hey people.

I was tasked with making a macro which combines two ranges into one pdf, one sheet for each range, and sends the single pdf to a list of emails. I have managed to get two seperate pdfs sent to the email list, but I am pretty stumped on how to combine the ranges. I initially came across some promising resources with Adobe Acrobat on this post Loop through files in folder that match part filename, but of course my computer doesnt have the software, and even if I were to get it, this Macro needs to work on many employees computers, so no cigar there. Perhaps if there were a way to get this software installed like a Reference? (this seems like a longshot to me)

My other idea was to copy the two ranges onto a new worksheet, "join them" together and just select the two ranges as one. This does work, but it absolutely messes up the formatting (merged cells, different column widths and row heights, different widths of ranges in general), so while this could work there may be a simpler way.

Does anyone have any suggestions as to what I could do? I can post my code if necessary but this seems more like a brainstorming sort of problem. Ill make sure to post my edited finished code if I manage to solve this particular part.

Many thanks and happy 2022!

 

[BSALV]

Sub Print_2Ranges()
     '2 ranges in the same sheet
     Range("A3:E7,A9:E30").ExportAsFixedFormat Type:=xlTypePDF, Filename:="C:\Data\Stal_Excell\Map1.pdf", OpenAfterPublish:=True

     '2 ranges in different sheets
     Sheets("blad1").PageSetup.PrintArea = "A1:D10"
     Sheets("blad2").PageSetup.PrintArea = "A3:F10"
     Sheets(Array("blad1", "blad2")).Select
     ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:="C:\Data\Stal_Excell\Map2.pdf", OpenAfterPublish:=True
End Sub

perhaps later add other stuff like zoom, margins, headers, etc

 

[Mescoman]

Wow you can just place two ranges in the ".ExportAsFixedFormat" command, that is super simple. Thank you very much, it worked perfectly. If I could trouble you to help me with the zooms/margins Id appreciate it, though even if you dont your solution exactly solves my question.

 

[BSALV]

With 2 ranges on the same sheet, it's difficult to zoom, etc because you can make it perfect for just 1 range.
There is another feature, the camera. (see

i didn't look at that video, but i suppose it's educative)
You use that camera in another sheet, but with a screenshot to the 2nd range of your original sheet.

Then you export like the 2nd option in my post, 2 ranges in 2 different sheets.

In more complex situations, you can also be creative and use multiple cameras in the same sheet,
Make them all the same size and underneath each other with at least 1 free row in between.
When that is done, use method 1 "2 ranges on the same sheet)