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”.
|Published (Last):||28 January 2004|
|PDF File Size:||10.70 Mb|
|ePub File Size:||7.55 Mb|
|Price:||Free* [*Free Regsitration Required]|
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.
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.
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
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?