Please help with this one. My program uses an excel template to print but I have recently discovered that because of the time it takes on the network printer the EXCEL object stays open even after my program is finished with it. Is it possible for me to (via VB
) check the status of my print job and then "kill" the EXCEL object?
I do set the objects to nothing and do close the workbook, but because of the fact that the printing took a bit longer, the object still remains open in the task manager. The only thing to do is to let the application "hang" until the printing is finished - but for this I need to query the printer object.