Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Fixed sized printout XY-diagram
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...- TopSat
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Left and top margins - Excel VBA
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...- TopSat
- Thread
- Replies: 6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Printerobject DeviceContext
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...- TopSat
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
