Sending documents to the printer

[bpeirson]

I am trying to find a way to send an image file to my printer when its name appears in a cell in an Excel spreadsheet.

I would like to avoid inserting the image into the spreadsheet and then printing it.

Any help or suggestions are appreciated.

I would also appreciate help with keywords to search the help files for.

 

[alexit]

You have file name stored in Excel, you can activate the computers imaging software (Paint if .BMP) then you can call Paint's print function from VB.

Check out

http://www.freevbcode.com

for downloadable examples.

 

[bpeirson]

Thanks, I have also added the Microsoft Office Document Imaging (MODI) library to my VBA editor.

My skills with VBA are primarily focused on Excel so I would still appreciate any input using other applications.

 

[handleman]

IrfanView is a freeware image viewer with command line capabilities. You could build a command line string to print the file through IrfanView and run the string with a wsh.shell object.