Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default CHANGING PRINTER DEFAULTS

I HAVE THE FOLLOWING CODE TO CHANGE THE DEFAULT PRINTER
WHEN I WANT TO PRINT A PDF FILE. THIS WORKS FINE MOST OF
THE TIME BUT EVEY ONCE IN A WHILE IT HANGS BECAUSE THE PDF
PRINTER IS ON "Ne01". IF I CHANGE THE VALUE FROM Ne00 to
Ne01 THE ROUTINE WILL CONTINUE.

QUESTION: WHAT IS Ne00, Ne01, etc WHY IS IT CHANGING



CurrentPrinter = Application.ActivePrinter ' Store
current printer.
Application.ActivePrinter = "PDF995 on Ne00:" ' Change
Printers."
ActiveWindow.SelectedSheets.PrintOut ' Print the
active document.
Application.ActivePrinter = CurrentPrinter ' Set
printer back to current.
ActiveWorkbook.Close
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default CHANGING PRINTER DEFAULTS

I am having the exact Question. To Change my activeprinter in need the "on NEnn". I looked at Enumprinters and do not see the "NEnn" being returned there. I am trying to create an automatically printing spreadsheet and can't affort to hard code this in the Code and have it fail. If anyone can enlighten us as to what this NEnn is and how to fiind it that would be great! Thanks!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing defaults [email protected] Excel Discussion (Misc queries) 1 August 14th 06 08:57 PM
Changing Excel defaults Tom Kreutz Excel Discussion (Misc queries) 2 March 2nd 06 02:25 PM
Changing defaults JRD Excel Discussion (Misc queries) 1 July 25th 05 05:15 PM
Changing Defaults in VBA JohnUK Excel Discussion (Misc queries) 3 February 28th 05 11:59 PM
Changing Defaults in VBA 2 JohnUK Excel Discussion (Misc queries) 1 February 27th 05 06:59 PM


All times are GMT +1. The time now is 01:47 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"