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.

Author: Nelar Doule
Country: Tajikistan
Language: English (Spanish)
Genre: Sex
Published (Last): 26 January 2015
Pages: 316
PDF File Size: 15.25 Mb
ePub File Size: 2.17 Mb
ISBN: 376-3-27535-744-2
Downloads: 54752
Price: Free* [*Free Regsitration Required]
Uploader: Mezitilar

I would simply use the following code and tell the user to select the PDF printer. WIth Acrobat 9 Pro, this registry setting no longer works as it did in 5.

VBA Visual Basic for Applications (Microsoft) FAQ

Should i just dim as variant as well? This tool uses JavaScript and much of it will not work correctly without it enabled. Where is the Main Index page of the old Woody’s Lounge?

Click here activeprinrer more information on our Cookie Policy and Privacy Policy. By continuing to use our website, you agree to the use of such cookies.

Help finding Active printer “on Ne02” the bottom code writes a line to the registry, which is unlikely to do what you want what it does is to set the file name for the next file to be printed by the acrobat pdf printer driver, this does not affect the activeprlnter the pdf driver is on. To start viewing messages, select the forum that you want to visit from the selection below.


Is this a Postscript file? However, the results are the same. Results 1 to 10 of 17 Thread: How do I configure the display of members’ images and signatures? In place of the Please let me know if this works for you!

  DD FORM 2766 PDF

Thanks for the help Aandi! When I record a macro to set the Excel printer to Adobe at different times from the same PCI get various answers, i. Sorry, I have no idea why it doesn’t work, but do try it with a local file name.

When I distribute the code to other users their Adobe printer might be associated with “Ne01” causing an error. We may share certain information about our users with our advertising and analytics partners. The trick is to do the send key first, thereby putting it into the buffer.

This activity is happening in a program running in a batch mode. It gets changed to a prn file when I execute the Macro I currently have defined – in an attempt to save it is C: Has anyone found a bullet-proof solution to this? ActivePrinter to save whatever printer the user was printing on and reset it afterward, but Application. Help finding Active printer “on Ne02” ok guys It is a file formatted to be sent to a printer.

The file I am working with is a.

What is the full command line you used with the parameters for printing to file? I have Excel and Adobe Acrobat v6. What you have to do is create a printer on your local computer that is linked to an Acrobat Distiller on another pc, which in this case is a server we always have up. Reply With Quote 0 0. Under create a new port select Local Appliccation, then click next.

Help finding Active printer “on Ne02”

Help finding Active printer “on Ne02” to get all the available printers with ports into a list box or array Code:. I had used the PrintOut command with Acrobat 5.


This is driving me nuts! Problem is the Adobe part. The default PDF activepringer name will be same as the source Excel file. Which will ultimately find the adobe print and use the right address? If you wanted the entire workbook, rather than the acitvesheet, you will need to select all the tabs.

Hi westconn1 I used your code but i get an error on “Arr” stating that variable not defined. It seems to work fine as long as you don’t include the PrToFileName: You also acknowledge that this forum activeprintre be hosted outside your country and you consent to the collection, storage, and processing of your data in the country where this forum is hosted.

Here is a sample PS file you can distill: Even if I give a name with the extension. 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: Thanks for all the help!

Runs best on HiVelocity Hosting. Help finding Active printer “on Ne02” dim arr as variant. Alternatively, I suppose I could export the registry to a text file and do a search, but that seems like a very inelegant solution.

I haven’t tested extensively, but Applifation think it will work. Help finding Active printer “on Ne02” oooof! Place Excel into table with ability to link when native Excel file is updated. This doesn’t work either, and I am getting frustrated. Help finding Active printer “on Ne02” Hi there! The time now is