Convert Spreadsheet to PDF (Button/Macro)

Hi,
I have coded a button, so that when pressed it will generate a pdf of the combined print areas of the three pages on my spreadsheet. (I have made sure to set the print areas on each page). However, when pressing, it generates the pdf, but each print area does not stay on its own page (because the width is too big). I was just wondering what to add to the code to ensure each print area stays on its own page. Thanks.

Please Login or Register  to view this content.

.
The suggestions at this resource have not been confirmed here. This is a reputable site though.
See if something at this URL can assist you:

https://stackoverflow.com/questions/...e-converting-u

Thanks!! Legend

Let us know how it turns out.

I have had a look at all the different bits of code on there, the following is the only one that is working:

Please Login or Register  to view this content.

However, although it is shrinking the document into 1 page (width wise), it is making it tiny and barely filling up half of the page.

.
I'm not certain you will be able to get three pages shrunk down to one for printing. At least I have never been able to.

Changing the display to Landscape, reducing the margins and manipulating the PRINT AREA on the worksheet ... I've been able to get maybe 1 1/4 pages on one
print page. That is, so the printed product is readable.

Accidentally, I've managed to get more than that on one printed sheet but the print was so small, you couldn't read anything ..... not usable.

Anyone else have a suggestion ?

It's strange, because the original code that i was using is supposed to save each print area onto a pdf. I have checked the print areas, and done a print preview and on that, just by default the entire print area fits the size that it should (i.e. width on one page). I'm just unsure as to why my code could not convert that to pdf

I have just checked, the code below works when the print area selected is reasonably small. It seems that as soon as I pick a larger vertical selection that it is trying to retain its proportions, and hence as it increases in size vertically, it reduces horizontally.

Please Login or Register  to view this content.

Just did a quick check, the pdf that the above creates, is exactly the same dimensions as if you print preview the set print area and select fit to one page. upon pressing fit all columns to one page, the print preview creates the dimensions that i want. I just need to find a way to code the "Fit all columns on one page" into my macro

Fixed it, literally all i had to do was go back to the other code and change some of the page setup properties

Please Login or Register  to view this content.

.
Great !

I was getting confused ... at first I understood the problem was how much of the sheet you could get printed on one sheet in the PDF.

Then you said it wasn't converting to PDF.

Here is a small macro I use to convert the active sheet to a pdf. I adjusted the margins to zero, orientation was horizontal (landscape) and I selected print to one sheet.
The print area was set from Col A to Col Z and down to row 100. It managed to get all of it on the page ... but barely readable. It's not so small a print that it can't be
understood but certainly would make for tired eyes after awhile.

Please Login or Register  to view this content.

Let me see what your macro does. ......

.
Your's creates pretty much the same thing. I'm surprised it was able to get all 26 columns and 100 rows on one sheet in PORTRAIT mode.

Thanks for your help
I have another quick question:

Using the code below, the macro will create a pdf containing the 3 sheets that i have defined in the array. The page setup part is working completely fine. I was just wondering if i could make it so that the "Summary" Page is put at the top of the pdf.

Please Login or Register  to view this content.

.
Interesting question.

After messing around with it, it appears the order in which the tabs appear from left to right, dictate the order they will appear in the PDF.

Let me see if there is vba code that does the same.