Hello,
I have small question about printing graphic file. How send to printer picture ( graphic file) under VBA
How print picture
Hot Topic
Microsoft ISV
- Runtime error 1004 when adding a seriescole to a chart
- MS Access VBA - Controlling Textbox in Forms
- Vba commands used to connect to sql
- Outlook email information reader/extractor
- Automaticly updating charts in excel
- Problem with VBA script
- VBA How to cope with unicode strings
- Runtime error '13' - type mismatch problem! Again...
- What is Team Suite Trial Edition?
- "unable to get the pivotfields property of the pivot table class"
How print picture
Adarsh Sridhar
Per our support engineer:
Hi, you need a container in office to contain that picture, then print it out. For example, you can insert that picture into a word file, then print that word doc.
Here is a sample code for you.
===
Selection.InlineShapes.AddPicture FileName:= _
"C:\Documents and Settings\jozhou\My Documents\My Pictures\100_5903.jpg", _
LinkToFile:=False, SaveWithDocument:=True
ActivePrinter = "\\sha-fp-01\23.036HP8150DN"
Application.PrintOut FileName:="", Range:=wdPrintAllDocument, Item:= _
wdPrintDocumentContent, Copies:=1, Pages:="", PageType:=wdPrintAllPages, _
ManualDuplexPrint:=False, Collate:=True, Background:=True, PrintToFile:= _
False, PrintZoomColumn:=0, PrintZoomRow:=0, PrintZoomPaperWidth:=0, _
PrintZoomPaperHeight:=0
===
-brenda (ISV Buddy Team)