Search results for query: *

Hi there, I'm trying to persuade Excel to print out my XY diagrams with always the same size (full letter). First a open a full sized diagramm on the screen and ask for the values of plotarea.width and plotarea.insidewidth. After each vhange of the content of the diagram I force...

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...

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...

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...

Hi HughLerwill, the crucial tip was CreateDC. Thank you for your support. TopSat

Hi there, I'm looking for a way to determine the handle of the actual printer. Printer.hdc does not work in excel/vba, there is no printer object definition. Background: I want to know some printer properties like resolution using the GetDeviceCaps call, but there I have to pass the printer...