printable area size

[Boba]

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]

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 here:
http://vb.mvps.org/samples/project.asp?id=prninfo

NickHK