I set the Active Printer [Printer=”Adobe PDF”]. I open the word document [(“path&”) path. I’ve downloaded the Acrobat SDK and have found the VB sample for AdobePDFSilent. PrintOut copies:=1, ActivePrinter:=”Adobe PDF”. However the client wants to use the Acrobat “Adobe PDF” printer instead. Each PDF must ut ActivePrinter:= “Adobe PDF”.
|Published (Last):||21 June 2017|
|PDF File Size:||14.72 Mb|
|ePub File Size:||11.52 Mb|
|Price:||Free* [*Free Regsitration Required]|
VBA Macro To Print To PDF Via Specific Printer – Free Excel\VBA Help Forum
I am trying to determine if active printer supports A3 page format.
VBA Visual Basic for Applications (Microsoft) FAQ
Obviously, my approach above didn’t work, so what is the way to do this? Maybe I am missing something? Here is a sample PS file you can activeprinteg What am I doing wrong?
Excel active printer port
Friday, April 8, 2: However, there still should be an additional check done to see if that printer really supports that feature. The file created is a prn file.
This content has been marked as final. The first one defaults everything after selecting the Acrobat PDF printer.
The content you requested has been removed. Thank you both for your responses and willingness to work with me on this problem. Is there really no API that could provide active printer name and port?
In Lithuanian version “on” is replaced with “, esanti”, but I have no idea how it would be replaced in Japanese or Greek languages. It looks like that starts a different Adobe DF printer to the one that would look at the registry.
Go to original post. Net as I don’t have any of the data types available that are created in the code. Friday, April adohe, This forum makes me laugh… for a week now I have had dual personalities. However, the only entry there is: Second code provides a list of available printers. Each PDF must have a name as specified in the code and must be sent to a specified folder, again as specified in the code. I guess that we are asobe the same thing in different ways.
Sunday, April 10, Sunday, April 10, 2: I can then leave out the bridgetalk stuff then. Thanks for your help. Please enter a title. I’ve been trying to create a macro for Word documents that will write the document out as a PDF and named as C: This content has been marked as final. The problem usually is to figure out what application name to use for your specific case. Karl Heinz, I’ve tried that based on my initial post see the code there.