I am using a listbox to select items to print out. The listbox is controlled by the input of two other combo boxes. My problem is that these items I need to print are Word or Excel files. My listbox allows the user to select one or several different documents and they may be all Word or all Excel or both. The items in my listbox are not constant, we have almost 20 departments with as little as 2 or as many as 25 files per department, so the items in my listbox are constantly changing depending on the department chosen.
My question is does anyone know how to open word or excel, print out the document and close the one that was just printed and then move to the next item selected in the listbox? Any help is much appreciated.
My question is does anyone know how to open word or excel, print out the document and close the one that was just printed and then move to the next item selected in the listbox? Any help is much appreciated.
