ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   printable area size (https://www.excelbanter.com/excel-programming/392476-printable-area-size.html)

Boba

printable area size
 
Hi;
trying to maximize amount of printable info
i need to retrieve printable area width:
paper width and printer non-printable gaps.
is GetDeviceCaps my only option?
thanx



NickHK

printable area size
 
With VB5/6 and its Printer object (or using API printer calls) the
non-printable margins have meaning.

Using Excel/VBA I don't see why you would need to, as Excel adjusts the
HPageBreaks/VPageBreaks/PrintArea according to the papersize, the set
printers capabilities and other settings.
Whilst you can of course handle this yourself, you are probably going to
inaccurate/wrong.
Why do you need this info ?

You can get a lot of printer(s) info from he
http://vb.mvps.org/samples/project.asp?id=prninfo

NickHK

"Boba" wrote in message
...
Hi;
trying to maximize amount of printable info
i need to retrieve printable area width:
paper width and printer non-printable gaps.
is GetDeviceCaps my only option?
thanx






All times are GMT +1. The time now is 06:47 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com