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: Zulkitaxe Tozuru
Country: Lithuania
Language: English (Spanish)
Genre: Finance
Published (Last): 21 December 2011
Pages: 150
PDF File Size: 17.64 Mb
ePub File Size: 19.8 Mb
ISBN: 508-1-39660-895-5
Downloads: 70124
Price: Free* [*Free Regsitration Required]
Uploader: Dushicage

Writing to network drives can be an issue. The switch to Adobe Acrobat 9 Pro is necessitated by the need to process documents with Chinese characters. I can return the printers collection, but it doesn’t give me the pesky NE number. Help activepronter Active printer “on Ne02” Hi there! I would simply use the following code and tell the user to select the PDF printer.

I had used the PrintOut command with Acrobat 5. All times are GMT Same operating system, same everything, so I’m not sure what the issue is with making a new local port. The time now is Even if I give a name with the extension. Which will ultimately find the adobe print and use the right address? Click here for more information on our Cookie Policy and Privacy Policy. Here’s where my VBA skills get stuck.

Thanks for the help Aandi! We always have to do several PDF for the same excel file. I acitveprinter the same question Show 0 Likes 0. The problem with Excel is that we cannot convert a excel file including several sheets. We process personal data about users of our site, through the use of cookies and other applicatikn, to deliver our services, personalize advertising, and to analyze site activity.

When it asks you for a printer, select Apple LaserWriter Pro and finish the printer installation. I really don’t want to have to resort to having the user do this manually.


ActivePrinter to save whatever printer the user was printing on and reset it afterward, but Application. Next in your code, use cativeprinter along the lines of this: Please type your message and try again.

Sorry, I have no idea why it doesn’t work, but do try it with a local file name. You can not post a blank message. Help finding Active printer “on Ne02” dim arr as variant. Problem is the Adobe part. Ozgrid is Not Associated With Microsoft.

VBA Visual Basic for Applications (Microsoft) FAQ

It is a file formatted to be sent to a printer. All contents Copyright by MrExcel Publishing. All times are GMT How can I be notified when my favorite forums contain new threads? The time now is If this is your first visit, be sure to check out the Board FAQ by clicking the link above. I have Excel and Adobe Acrobat v6.

set default printer to Adobe PDF (/XP) | Windows Secrets Lounge

I just had to dig a little deeper in the thread. I haven’t tested extensively, but I think it will work.

Help applicztion Active printer “on Ne02” does this help http: Is this a Postscript file? The time now is All times are GMT.

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: Does anyone know if i should replace the bottom strip of code with the top and also, i get a variable not defined on the top code for reg and regvalue.

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.