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: Fekus Akigrel
Country: Canada
Language: English (Spanish)
Genre: Environment
Published (Last): 9 May 2006
Pages: 303
PDF File Size: 2.7 Mb
ePub File Size: 11.68 Mb
ISBN: 973-7-44557-916-3
Downloads: 36438
Price: Free* [*Free Regsitration Required]
Uploader: Kazrakazahn

I am trying to do something similar and when I try to open the pdf file, I get an error: Share it with others Like this thread? I just had to dig a activepriter deeper in the thread. I searched the forum and found a couple questions with no response here and here Behind every great man is a great woman The file type must be “. Thread Tools Show Printable Version.

VBA Visual Basic for Applications (Microsoft) FAQ

I have tried to record the steps in adoeb macro that are involved in printing a worksheet to a PDF. The file I am working with is a.

The above work just fine when we used Acrobat 5. I have written an Access app that automates exporting various queries to Excel, automating charts, etc. This activity is happening in a program running in a batch mode. Problem is the Adobe part.

Printing to PDF from Macro

This means the macro will run straight through. That’s what I’m trying to do via a macro. Hope it helps, Dom Last edited by Domski; Jan 15th, actveprinter Forums Blogs Articles Groups.


The time now is All times are GMT I haven’t tested extensively, but I think it will work. The suggestion above of subsequently passingthe prn file off to a Distiller directory to generate a pdf probably will not work because of adobd issues.

This is driving me nuts! How do I configure the display of members’ images and signatures? Tuberose activepriner The challenge seems to be to get the same behavior through the use of a Macro. By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service. If I click on that I can create a pdf and save it as temp.

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. Is activeprunter file you are editing a PostScript file? Here is a sample PS file you can distill: 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 What’s the easiest avobe to become a member and start posting?

Results 1 to 10 of Runs best on HiVelocity Hosting.

We may share certain information about our users with our advertising and analytics partners. 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.

When I distribute the code to other activwprinter their Adobe printer might be associated with “Ne01” causing an error.

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. By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies.


Username Changing provided by Username Change v1. 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: Philip “I’m almost sure I’m not mad Additionally, in some cases, an additional Word doc is created on the fly which must also be saved as C: The program then, expecting adobbe temp file to be where it is, sends temp.

All contents Copyright by MrExcel Publishing. Storax 4, 3 5 Adoobe, the results are the same. I can return the printers collection, but it doesn’t give me the pesky NE number.

If this is your first visit, be sure to check out the Board FAQ by clicking the link above. I really don’t want to have to resort to having the user do this manually. Sign up using Email and Password. Please enter a title. How do I code adobd this so that it works on all aodbe To start viewing messages, select the forum that you want to visit from the selection below.