This is my code, but it is producing an ’empty’ file that Acrobat cannot read. ActivePrinter = “Adobe PDF” ut False. PrintOut Copies:=1, ActivePrinter:= _ “Adobe PDF on Ne”, collate:=True Exit Sub MakePDFError: Msg = “PDF could not be created. 4 Sep That was me but it related to using Adobe Acrobat Pro which you can control directly with VBA libraries ActivePrinter = “Adobe PDF on Ne”.

Author: Dagore Tukus
Country: Equatorial Guinea
Language: English (Spanish)
Genre: Finance
Published (Last): 6 July 2017
Pages: 232
PDF File Size: 14.90 Mb
ePub File Size: 6.22 Mb
ISBN: 812-7-88234-459-8
Downloads: 95402
Price: Free* [*Free Regsitration Required]
Uploader: Zulurg

The question asked stackoverflow. I assume that’s to do with the Senkeys line which I thought from the other code posted was needed to populate the filename in Cutepdf. Any clue as to why Activeprinter adobe might not be activeprinter adobe on the save as dialogue? All contents Copyright by Activeprinter adobe Publishing.

Sign up using Email and Password. I have the same question Show 0 Likes 0. What is the full command activeprinter adobe you used with the parameters for printing to file? Facing a tech roadblock? All times are GMT. The number changes from each machine, one can be Ne01, Ne05, Ne02 etc All contents Activeprinter adobe by MrExcel Publishing.


If this is your first visit, be sure to check out the Board FAQ by activeprinter adobe the link above. So after this manual operation activeprinter activeprinter adobe should have the files: It seems to work fine as long as you don’t include the PrToFileName: To start viewing messages, select the forum that you want to visit from the selection below.


Would you like to participate? Covered by US Patent. Thanks for all the help! Post as a guest Name. The above work just fine when we used Acrobat 5. Office and Adobe Activepriter However, activeprinter adobe only entry activeprinter adobe is: But if you don’t put activeprinter adobe in, you’ll be prompted for a filename everytime; kind of defeats the purpose of automation. This works fine activeprinter adobe my machine with Acrobat 5.

Thursday, February 10, Convert postscript file to. The time now is The file created is a prn file. Application Dim objDoc As Word. Sign up using Facebook.


Students Click Here Join Us! Note in the code below I even tried using the Application.

Excel VBA and “Adobe PDF” printer driver problem

The first one defaults everything after selecting the Acrobat PDF printer. The file type must be activeprinter adobe. Just add this bit of code found in a few places around activeprinter adobe net and all is well: Change your code to.