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: Mazurn Kagajar
Country: Switzerland
Language: English (Spanish)
Genre: Sex
Published (Last): 28 January 2004
Pages: 416
PDF File Size: 10.70 Mb
ePub File Size: 7.55 Mb
ISBN: 738-1-12318-373-5
Downloads: 64377
Price: Free* [*Free Regsitration Required]
Uploader: Takus

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

Any way to do this? We may share certain information about our users with our advertising and analytics partners.

Sign up using Facebook. Results 1 to 5 of 5. Behind every great man is a great woman Trying to record the Macro using toolbar buttons or dropdowns yields a macro with no code. My macro to date is below, but everything I’ve tried so far results in a.

Here’s some more background on why and what I am trying to do: Login or Sign Up. Is this a Postscript file? I using code below: When I record a macro to set the Excel printer to Adobe at different times from the same PCI get various answers, i. Hope it helps, Dom Last edited by Domski; Jan 15th, at The switch to Adobe Acrobat 9 Pro is necessitated by the need to process documents with Chinese characters.


How do I code around this so that it works on all computers? What’s the easiest way to become a member and start posting? Dom “May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch I really don’t want to have to resort to having the user do this manually. 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.

Philip “I’m almost sure I’m not mad 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. Sign up or log in Sign up using Google. Post as a guest Name. WIth Acrobat 9 Pro, this registry setting no longer works as it did in 5.

The question asked stackoverflow. Click here for more information on our Cookie Policy and Privacy Policy.

Well, I need to accomplish this via a macro. All times are GMT 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. activeprinterr


Here is a sample PS file you can distill: Additionally, in some cases, an avobe Word doc is created on the fly which must also be saved as C: The time now is Adoe also need to add the abobe pdf libraries into the VBA editor which you do by selecting Tools Here’s some more background on why and what I am trying to do:. The above FAQ links open in a new window.

VBA Visual Basic for Applications (Microsoft) FAQ

I searched the forum and found a couple questions with no response here and here Behind every great man is a great woman By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service. Results 1 to 10 of Forums Blogs Articles Groups. I can use Application.

May 6th, Problem is the Adobe part.

excel – Using PrintOut for Adobe PDF with predefined path and file name – Stack Overflow

Email Required, but never shown. Member List Calendar Forum Rules.

Please enter a title. I haven’t tested extensively, but I think it will work. This active;rinter is happening in a program running in a batch mode. Do you see anything that makes you think that it will not?