I have an excel spreadsheet that will combine workbook tabs to create an adobe file. The code to set the printer to adobe is. Application. ActivePrinter to save whatever printer the user was printing on and reset it afterward, but Printer = “Adobe PDF” doesn’t work. ut _. Copies:=1, ActivePrinter:=”Adobe PDF on Ne”, PrintToFile:=True, Collate:=True, PrToFileName:=sSheetName & sSuffix & “.pdf”.

Author: Nikokus Shakatilar
Country: Reunion
Language: English (Spanish)
Genre: Spiritual
Published (Last): 10 August 2006
Pages: 128
PDF File Size: 8.12 Mb
ePub File Size: 11.32 Mb
ISBN: 138-7-55130-733-1
Downloads: 18318
Price: Free* [*Free Regsitration Required]
Uploader: Vor

How do I code around this so that it works on all computers? Resources saved on this page: Please enter a title.

Has anyone found a bullet-proof solution to this? You can not post a blank message. Adohe Acrobat 9 Pro, this registry setting no longer works as it did in 5.

When I record acitveprinter macro to set the Excel printer to Adobe at different times from the same PCI get various answers, activepprinter. Here’s some more background on why and what I am trying to do:. How should I configure my browser to get the greatest benefits from the Lounge? This is because, with the same document opened in Word, I aciveprinter select the ‘Convert to Adobe PDF’ toolbar button and this creates a temp. Application Dim objDoc As Word.

This activity is happening in a program running in a batch mode. I have written an Access app that automates exporting various queries to Excel, automating charts, etc. Is this a Postscript file?


The file I am working with is a. You’ll also need to add the abobe pdf libraries into the VBA editor which you do by selecting Tools I am trying to print to a PDF file from Excel which is relatively simple to do. Thank you, in advance, for your activeprintter. We may share certain information about our users with our advertising and analytics partners.

Printing to PDF from Macro

All contents Copyright by MrExcel Publishing. Username Changing provided by Username Change v1. Results 1 to 5 of 5. The code I posted avobe with Adobe 6. I’m guessing you’ll need to check if PrimoPDF has similar libraries that you can install or if it can even be controlled with VBA in the first place. Ozgrid is Not Associated With Microsoft.

Here is a sample PS file you can distill: Help Contact Us Go to top.


I am trying to do something similar and when I try to open the pdf file, I get an error: I turned it into a little function, which works great: If the contents of the file has all the correct formatting and syntax, a PDF file will be placed in the special “OUT” folder.

This program is using OLE to open Word documents, add watersmarks and other details, then save the changed Word doc as a pdf to c: That’s what I’m trying to do via a macro. Share it with others Like this thread? I using code below: 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.

  HCS12 9S12 PDF

VBA Visual Basic for Applications (Microsoft) FAQ

I have tried to record the steps in a macro that are involved in printing a worksheet to a PDF. Stack Overflow works best with JavaScript enabled. Please turn JavaScript back on and reload this page.

May 6th, Printing to PDF from Macro. The problem is that when I select the Adobe printer it appends the selection with a reference to “Ne I haven’t tested extensively, but I think it will work.

Please type your message actiiveprinter try again. If this is your first visit, be sure to check out the Board FAQ by clicking the link above. Alternatively, I suppose I could export the registry to a text file and do a search, but that seems like a very inelegant solution.

Runs best on HiVelocity Hosting. The question asked stackoverflow.