Printer = “Adobe PDF on Ne” edSheets .PrintOut Copies:=1, ActivePrinter:= _ “Adobe PDF on Ne”. Private Sub cmdMakePDF_Click() Dim Msg As String On Error GoTo MakePDFError: Printer = “Adobe PDF on Ne”. Problem is the Adobe part. I can use Printer to save whatever printer the user was printing on and reset it afterward, but.

Author: Duzilkree Nirn
Country: Kazakhstan
Language: English (Spanish)
Genre: Personal Growth
Published (Last): 22 March 2004
Pages: 329
PDF File Size: 16.56 Mb
ePub File Size: 2.38 Mb
ISBN: 220-8-70626-162-6
Downloads: 35075
Price: Free* [*Free Regsitration Required]
Uploader: Vilkree

This works fine on my machine with Acrobat 5. Share it with others Like this thread? How do you build the. Help finding Active printer “on Ne02” Hi there! The above FAQ links open in a new window.

Member List Calendar Forum Rules. Please turn JavaScript back on and reload this page.


Has anyone found a bullet-proof solution to this? How do I code around this so that it works on all computers? The file created is a prn file.

I saw code on here before as to how to find the proper “port” but after a bit of searching, i cant find it again. Login or Sign Up. Using this methodology, I did not require the API code. I really don’t want to have to resort to having the user do this manually. What is the full command line you used with the parameters for printing to file?

WIth Acrobat 9 Pro, this registry setting no longer works as it did in 5. We process personal data about users of our site, through the use of cookies and other technologies, to deliver our services, personalize advertising, and to analyze site activity. May 7th, Now you should have the printer setup locally on your pc.


I’ve seen some references to PDF Appliaction and perhaps this is a product that needs to be added to this process, but I can’t find complete information on this product. Then name the port C: I have Excel and Adobe Acrobat v6. Please enter a title. Correct Answers – 10 points. Activerpinter finding Active printer “on Ne02” ok guys Applicatioj time now is The issue I’m having is that I’m not able to automate creating the PS file with the PrintOut method due to a box popping up and asking me to input a file name for the pdf file.

If you wanted the entire workbook, rather than the acitvesheet, actuveprinter will need to select all the tabs. ActivePrinter to save whatever printer the user was printing on and reset it afterward, but Application. Should i just dim as variant as well?

Help finding Active printer “on Ne02” oooof! This tool uses JavaScript and much of it will not work correctly without it enabled. Click here for more information on our Cookie Policy and Privacy Policy. Axtiveprinter always have to do several PDF for applifation same excel file.

Reply With Quote 0 0. Ozgrid is Not Associated With Microsoft. Become a Registered Member free to remove the ad that appears in the top post. Help finding Active printer “on Ne02”. It seems to work fine as long as you don’t applicatioon the PrToFileName: Even if I give a name with the extension. You can not post a blank message. I can return the printers collection, but it doesn’t give me the pesky NE number. Help finding Active printer “on Ne02” no, ne02 may already be in use when they install pdf driver but you can use a cut down version of the above code like this Code: All times are GMT The suggestion above of subsequently passingthe prn file off to a Distiller directory to generate a pdf probably will not work because of timing issues.


If anyone finds a fix feel free to post it on up here! Go to qctiveprinter post. I would simply use the following code and tell the user to select the PDF printer. The switch to Adobe Acrobat 9 Pro is necessitated by the need to process documents with Actuveprinter characters.

VBA Macro To Print To PDF Via Specific Printer – Free Excel\VBA Help Forum

This website uses cookies, including third party ones, to allow for analysis of how people use our website in order to improve your experience and our services. I have the same question Show 0 Likes 0. I appreciate you taking the time! I am trying to print to a PDF file from Excel which is relatively simple to do.

If this is your adob visit, be sure to check out the Board FAQ by clicking the asobe above. The challenge seems to be to get the same behavior through the use of a Macro.