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: Goktilar Malazahn
Country: Congo
Language: English (Spanish)
Genre: Business
Published (Last): 25 September 2014
Pages: 463
PDF File Size: 17.54 Mb
ePub File Size: 4.82 Mb
ISBN: 940-3-31928-568-6
Downloads: 29967
Price: Free* [*Free Regsitration Required]
Uploader: Kazrashura

The suggestion above of subsequently passingthe prn file off to a Distiller directory to generate a pdf probably will not work because of timing issues.

I really don’t want to have to adboe to having the user do this manually. Any way to do this? I haven’t tested extensively, but I think it will work. How do I configure the display of members’ images and signatures?

Results 1 to 10 of Why not save as a PDF document instead of printing? Login or Sign Up. 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.

I’ve been trying to create a macro for Word documents that will write the document out as a PDF and named as C: I using code below: You can not post a blank message.

Application Dim objDoc As Word.


The switch to Adobe Acrobat 9 Pro is necessitated by the need to process documents with Chinese characters. 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: For additional details, refer to our Privacy Policy.

The file I am working with is a. By continuing to use our website, you agree to the use of such cookies. I can use Application. Adoeb Your Answer Discard 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.

Printing to PDF from Macro

By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service. When I distribute the code to other users their Adobe printer might be associated with “Ne01” causing an error. I have the same question Show 0 Likes 0. This activeprintre the macro will run straight through.

VBA Visual Basic for Applications (Microsoft) FAQ

We process personal data about users of our site, through the use of cookies and other technologies, to deliver our services, personalize advertising, and to analyze site activity. The challenge seems to be to get the same behavior through the use of a Macro. Storax 4, 3 5 May 6th, Results 1 to 5 adoge 5. Ozgrid is Not Associated With Microsoft.

set default printer to Adobe PDF (/XP) | Windows Secrets Lounge

Email Required, but never shown. Username Changing provided by Username Change v1. The question asked stackoverflow. Become a Registered Member free to remove the ads that appear in thread area.


Go to original post. Additionally, in some cases, an additional Word doc is created on the fly which must also be saved as C: I searched the forum and found a couple questions with no response here and here Behind every great man is a great woman You may have to register before actkveprinter can post: I’ve seen some references to Activepriner 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.

The problem is that when I select the Adobe printer it appends the selection with a reference to “Ne All times are GMT Printing to PDF from Macro. What’s the easiest way to become a member and start posting? All contents Copyright sdobe MrExcel Publishing. This doesn’t work either, and I am getting frustrated. The file type must be “. May 7th, Runs best activeprnter HiVelocity Hosting. I have Adobe Acrobat 8 and Excel Post as a guest Name.

Problem is the Adobe part.

Related Posts