Printer = “Adobe PDF on Ne” edSheets .PrintOut Copies:=1, ActivePrinter:= _ “Adobe PDF on Ne”. Private Sub cmdMakePDF_Click() Dim Msg As String On Error GoTo MakePDFError: Printer = “Adobe PDF on Ne”. Problem is the Adobe part. I can use Printer to save whatever printer the user was printing on and reset it afterward, but.
|Published (Last):||22 March 2004|
|PDF File Size:||16.56 Mb|
|ePub File Size:||2.38 Mb|
|Price:||Free* [*Free Regsitration Required]|
This works fine on my machine with Acrobat 5. Share it with others Like this thread? How do you build the. Help finding Active printer “on Ne02” Hi there! The above FAQ links open in a new window.
Has anyone found a bullet-proof solution to this? How do I code around this so that it works on all computers? The file created is a prn file.
I saw code on here before as to how to find the proper “port” but after a bit of searching, i cant find it again. Login or Sign Up. Using this methodology, I did not require the API code. I really don’t want to have to resort to having the user do this manually. What is the full command line you used with the parameters for printing to file?
I’ve seen some references to PDF Appliaction and perhaps this is a product that needs to be added to this process, but I can’t find complete information on this product. Then name the port C: I have Excel and Adobe Acrobat v6. Please enter a title. Correct Answers – 10 points. Activerpinter finding Active printer “on Ne02” ok guys Applicatioj time now is The issue I’m having is that I’m not able to automate creating the PS file with the PrintOut method due to a box popping up and asking me to input a file name for the pdf file.
If you wanted the entire workbook, rather than the acitvesheet, actuveprinter will need to select all the tabs. ActivePrinter to save whatever printer the user was printing on and reset it afterward, but Application. Should i just dim as variant as well?
Reply With Quote 0 0. Ozgrid is Not Associated With Microsoft. Become a Registered Member free to remove the ad that appears in the top post. Help finding Active printer “on Ne02”. It seems to work fine as long as you don’t applicatioon the PrToFileName: Even if I give a name with the extension. You can not post a blank message. I can return the printers collection, but it doesn’t give me the pesky NE number. Help finding Active printer “on Ne02” no, ne02 may already be in use when they install pdf driver but you can use a cut down version of the above code like this Code: All times are GMT 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.
If anyone finds a fix feel free to post it on up here! Go to qctiveprinter post. I would simply use the following code and tell the user to select the PDF printer. The switch to Adobe Acrobat 9 Pro is necessitated by the need to process documents with Actuveprinter characters.
VBA Macro To Print To PDF Via Specific Printer – Free Excel\VBA Help Forum
If this is your adob visit, be sure to check out the Board FAQ by clicking the asobe above. The challenge seems to be to get the same behavior through the use of a Macro.