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: Dugar Samulkree
Country: Djibouti
Language: English (Spanish)
Genre: Spiritual
Published (Last): 13 April 2018
Pages: 323
PDF File Size: 12.32 Mb
ePub File Size: 9.28 Mb
ISBN: 927-5-14590-870-1
Downloads: 39976
Price: Free* [*Free Regsitration Required]
Uploader: Mezizuru

Aandi, can you help me?

VBA Visual Basic for Applications (Microsoft) FAQ

The file created is a prn file. Share it with others Like this thread? 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.

The switch to Adobe Acrobat 9 Pro is necessitated by the need to process documents with Chinese characters. I can use Application. You also acknowledge that this forum may be hosted outside your country and you consent to the collection, storage, and processing of your data in the country where this forum is hosted.

I would simply use the following code and tell the user to select the PDF printer. WIth Acrobat 9 Pro, this registry setting no longer works as it did in 5.

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

Help finding Active printer “on Ne02” to get all the available printers with ports into a list box or array Code:. I am trying to print to a PDF file from Excel which is relatively simple to do. This doesn’t work either, and I am getting frustrated.


That’s what I’m trying to do via a macro.


My macro to date is below, but everything I’ve tried so far results in a. Please let me know if this works for you! Well, I need to accomplish this via a macro. Results 1 to 10 of You don’t have JavaScript enabled.

I do have a workaround but it apolication having Adobe Acrobat 5 applicattion another PC. May 6th, Trying to record the Macro using toolbar buttons or dropdowns yields a macro with no code. The time now is The issue I’m having is that Wctiveprinter 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. Adboe 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.

There is probably a parameter to use. 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. Does anyone know if i should replace the bottom strip of code with the top and also, i get a variable axobe defined on the top code for applicatino and regvalue.

This used to work in the past!! When I distribute the code to other users their Adobe printer might be associated with “Ne01” causing an error. Do you see anything that makes you think that it will not? To start viewing applicatiin, select the forum that you want to visit from the selection below. Resources saved on this page: Even if I give a name with the extension.


What’s the easiest way to become a member and start posting? If so then that explains why you were not able to print to PS – I thought you were doing it manually! May 7th, When I record a macro to set the Excel printer to Adobe at different times from the same PCI get various answers, i. Help finding Active printer “on Ne02” dim arr as variant. Home Services Forums Advertise Contact.

I can return the printers collection, but it doesn’t give me the pesky NE number. I’ve seen some references to PDF Maker and perhaps this is a product that needs to be added to this process, but I can’t find complete information on this product.

Printing To Pdf This has been asked recently. It is a file formatted to be sent to a printer.

Here’s where my VBA skills get stuck. The challenge seems to be to get the same behavior through the use of a Macro.

Any ideas on how to fully automate the creation of the PS file?