Printing from a UserForm ListBox

[carsto]

Okay, I've done some work to solve the minor problems but the PRINTING is still an issue.
There has to be a way to do this with SHELL API AUTOMATION or something!

I have a macro that creates a ListBox1 in a UserForm called SelectToPrint

my code runs thru the selected items in the Listbox and converts them to their associated filepath

Example ListBox1 contains
Picture7
Picture12
Picture90
Picture45
Picture5

If the User Selects Entries Picture12 & Picture45 & Clicks the Print Command Button
The macro will generate the following File Locations:
C:\Files\Picture12.tif
C:\Files\Picture45.tif

Please Login or Register  to view this content.

My code then takes the filepaths and pops them into a message box (since I can't figure out what else to do with them!

I want to replace this message box with a command to sends these two files to a Default Printer, Shrunk to Fit. (no Print Previewing!)

The Reference Number returned from the InputBox needs to be in the Header on the printed page.

TIA

[carsto]

I just edited my original ppost.

Another option is instead of creating the filepath I could LOOKUP a cell containing a hyperlink, follow it and print.
1. I was concerned that a couple thousand hyperlinks might inflate my filesize and slow me down.
2. I can get it to follow the hyperlink , generating a preview in Windows Fax & Picture Viewer, but again I can't figure out how to automatically print it.

So it's an option, but to my newbie thinking, it's not a good option.
Just throwing it out there in desperation.