Link to home
Start Free TrialLog in
Avatar of Sandra Smith
Sandra SmithFlag for United States of America

asked on

Print any file type from VBA

I have a listbox with all the files in a directory.  These are mixed files types, workd, pdf, excel, etc.  Is there a way, when the user highlights the file name in the listbox and then hits print, to simply print the file without having to open it or use any type of object?  This is from an Access 2003 form in VBA.  The file types can also be 2003, 2007 or 2010 files.

Sandra
SOLUTION
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Sandra Smith

ASKER

Good information on both.  I finally told the user when they open the file, simply print from there.  Since they so rarely print I found out, this was the best way to solve the problem.

Sandra
OK,
Enjoy the weekend