View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default 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