Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: Blizzard9999
- Order by date
-
Excel 2010 - Change printer depending on choice
Ok, now I see what you were talking about! I forgot code tags! Those are hard to find on this forum.- Blizzard9999
- Post #28
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel 2010 - Change printer depending on choice
I included it. Same idea basically as your solution. I'm not an advanced user, so I found this one easier to understand once I had studied your posts. Here it is again: oldprinter = Application.ActivePrinter For i = 0 To 99 curNePrint = Format(i, "00") On Error Resume...- Blizzard9999
- Post #25
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel 2010 - Change printer depending on choice
In case anyone else is running into this. I came across another way to print with out the Ne#. You would need to fill in your printer address on this part \\Sever\SHARP MX-2600N PCL6 on Ne , be sure to include (add) the "on Ne" part. oldprinter = Application.ActivePrinter For i = 0...- Blizzard9999
- Post #23
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Excel 2010 - Change printer depending on choice
I'm having similar problems! I've been getting the printer address for years with office 2003. Similar what you said: 1) turning on the macro recorder, 2) Office Button 3) Print 4) Print 5) Change the Printer Selection 6) CANCEL and repeat as necessary to get three printers. I just received a...- Blizzard9999
- Post #22
- Forum: VBA Visual Basic for Applications (Microsoft)
