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”.
||9 May 2006
|PDF File Size:
|ePub File Size:
||Free* [*Free Regsitration Required]
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.
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.
When I distribute the code to other activwprinter their Adobe printer might be associated with “Ne01” causing an error.
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.