Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I must have misread. When the OP stated that it was Ne00 on other computers
I assumed he meant they actually had "Adobe on Ne00". He must be talking about the other printers that are installed. Obviously, I know little about printers. I just assumed he wanted to programmatically capture and set the active printer to Adobe, not actually set the Adobe "printer" name to something different. Thanks Nick! "NickHK" wrote: I'm no expert on printers, but you get "Adobe PDF on My Documents\*.pdf", because that is the virtual port that you have set, so Adobe defaults to that location when it "prints" its output. As such you cannot have "Adobe PDF on Ne01" because that is real port with a supposedly real printer connected. As Adobe PDF does not output real printer codes this would not be possible. NickHK "salut" wrote in message ... Thanks a lot! That's very helpful! But the strange thing is. When I was trying to print out the information. I just get "Adobe PDF on My Documents\*.pdf" instead of "Adobe PDF on Ne01". Could you tell me how can I get "Adobe PDF on Ne01". Thanks a lot! "JMB" wrote: I think Adobe PDF is the local name for the printer and Ne01 describes the network name for the same resource. Tom Ogilvy posted some resources to check out. http://www.microsoft.com/office/comm...xp=&sloc=en-us If you can return a list (or array) of all of the printers, I would think you could loop through the listing the identify which one has "Adobe PDF" in the name (check VBA InStr function). I only have one printer so I can't fully test the macro's suggested, but the one that uses WScript.Network (which you should have seen in Tom's old posts) seemed to work okay. At the very worst, you could have the user change the activeprinter using Application.Dialogs(xlDialogPrinterSetup).Show "salut" wrote: When I was trying to print to PDF file, I need to set the printer as "Adobe PDF on Ne01", could anybody tell me what this "Ne01" means? And how can I get that kind of information before I use them in the code? Because on some other computers, it is "Ne00" instead of "Ne01". Thanks a lot! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
If changed array formula reduce ""\""\""\ - signs to #Missing, will it make ... | Excel Programming |