Printing to Network Printer

[cabinetguy]

I have a spreadsheet that I have created for our customer service dept. that will automatically generate a page that is printed on our shipping and receiving dept. as well as place pertinent information on a traffic spreadsheet for tracking purposes.

I seemed to get everything working pretty well and wanted to move it to another co-workers computer for them to test. It seems that the Network printer in shipping and receiving wasn't recognized as Ne12:, so the first thing I need to do is somehow search to find out where the printer \\traffic\Traffic is located. I saw a code somewhere else that seemed to do this, but it locked my excel up as soon as I closed VB.

The other thing that I have noticed is that if the file "traffic.xlsm" isn't opened on the local machine, the code errors out. Can someone explain how to check to see if that sheet is opened and if not, open it before writing.

Thank you all for your help thus far and I am confident that someone can come up with a solution to my problem rather easily.

Please Login or Register  to view this content.

[cabinetguy]

I was able to come up with a solution using bits and pieces of other codes I've found.

Below are the fixes.

Please Login or Register  to view this content.