Left and top margins - Excel VBA

[TopSat]

HI there,

now i found a way to get informations about the non printable left and top margin of a printer using GetDeviceCaps (PHYSICALOFFSETX , PHYSICALOFFSETY).

But I can't find any information about the right and bottom margins. I assume they are different from the left and top offset. Does anybody know, where I find information about this topic?

The users settings about the margins are located in the printer driver. How can I read this settings?

Thanks in advance for any hint,

TopSat

 

[HughLerwill]

thread707-1009458 may (or may not) help

regards Hugh

 

[TopSat]

Hi HughLerwill,

thanks again for your advice. I know this thread, it was from you for me ,-)

Working is:

PHYSICALWIDTH
PHYSICALHEIGHT
PHYSICALOFFSETX
PHYSICALOFFSETY


but I still don't know, how to determine right and bottom offset. PHYSICALWIDTH and PHYSICALHEIGHT is the complete size of the actual paper.

This user can choose different settings for the margins in the printer driver. This values I can't read with GetDeviceCaps.

Thanks,

TopSat

 

[HughLerwill]

TopSat,

Sorry about that...
Thought it sounded familiar duh!

 

[HughLerwill]

TopSat,

Given Top and Left I guess you have the top margin and left margins so Bottom should be equal to topMargin+Printer.ScaleHeight and Right should be equal to Left+Printer.ScaleWidth. Think so anyway..

regards Hugh

 

[HughLerwill]

TopSat,

But you have no Printer object in VBA, eek!

Hugh

 

[TopSat]

Hi Hugh,

>>>But you have no Printer object in VBA, eek!

That's the point! So my idea is to read this settings out of the printer driver, but how?

Even if I know PHYSICALWIDTH and PHYSICALHEIGHT from GetDeviceCaps I still have no information about the current settings in the driver. And about right and bottom margin I know nothing through GetDeviceCaps.

Thank you,

TopSat