Way To Scale Word 2010 Document for Print as you can For Excel ?

KenWit

Board Regular
Joined
Nov 21, 2011
Messages
68
Hi,
I'd like to scale a Word document by percentage for print: increasing its size just as on a photocopier when you enlarge by a percentage. Is there a way to do that? Ideally, I'd increase my document by 160% so the text measures ~7.5" in width, up from 5" at present. I'm familiar with VBA if there's some sorta workaround.
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
Word's print dialogue has a 'Scale to Paper Size' option that allows you to re-scale a document to fit paper sizes other than the document's own page size, but that's about it.
 
Upvote 0
Thanks. I checked "scale to paper size" with the print dialogue box, thru VBA. Control-P calls up the ribbon tab now, so no direct way to call it up in 2010 it seems.

This kinda puts me in a bind that I can't enlarge text. Resizing all the font and spacing even with the ribbon option "increase font size" will be time consuming.

I may try pasting the text into an Excel cell in desperation and see what happens. (Probably the text will get jumbled.) Seems like there should be some solution.

Thanks for you help.
 
Upvote 0
For Word VBA, check out the .Printout method's PrintZoomColumn, PrintZoomRow, PrintZoomPaperWidth and PrintZoomPaperHeight arguments.
 
Upvote 0
Many Thanks! :)
Works like a charm:

ActiveDocument.PrintOut _
PrintZoomPaperWidth:=0.75 * (8.5 * 1440), _
PrintZoomPaperHeight:=0.75 * (11 * 1440)

Good one to you.
 
Upvote 0

Forum statistics

Threads
1,213,507
Messages
6,114,029
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top