Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I distribute columns evenly within the printable area XLS 03 | Excel Discussion (Misc queries) | |||
Copying printable area | Excel Worksheet Functions | |||
how can i extend the printable area up to the very last row | Setting up and Configuration of Excel | |||
error: "the copy area & the paste area are not the same size & sh | Excel Discussion (Misc queries) | |||
Set Printable area to skip columns | Excel Discussion (Misc queries) |