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 January 2007|
|PDF File Size:||16.5 Mb|
|ePub File Size:||9.20 Mb|
|Price:||Free* [*Free Regsitration Required]|
Help finding Active printer “on Ne02” oooof! For additional details, refer to our Actifeprinter Policy. I know that i also write in the french forum for the same topic but is to have best chance to solve my problem o: Home Services Forums Advertise Contact.
What’s the easiest way to become a member and start posting? We always have to do several PDF for the same excel file. If I find a;plication solution for it I’ll throw it up here! Member List Calendar Forum Rules.
set default printer to Adobe PDF (/XP) | Windows Secrets Lounge
I dont have a list combo. Page 1 of 2 1 2 Last Jump to page: But that won’t make a PDF. 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 actiiveprinter. I can return the printers collection, but it doesn’t give me the pesky NE number.
How do you build actveprinter.
WIth Acrobat 9 Pro, this registry setting no longer works as it did in 5. The trick is to do the send key first, thereby putting it into the buffer.
Help finding Active printer “on Ne02” ok guys The problem is that when I select the Adobe printer it appends the selection with a reference to “Ne The suggestion activeprrinter of subsequently passingthe prn file off to a Distiller directory to generate a pdf probably will not work because of timing issues.
You may have to register before you can post: Share it with others Like this thread? We may share certain applivation about our users with our advertising and analytics partners.
If the contents of the file has all the correct formatting and syntax, a PDF file will be placed in the special “OUT” folder. But if you don’t put that in, you’ll be prompted for a filename everytime; kind of defeats the purpose of automation.
Place Excel into table with ability to link when native Excel file is updated. I have written an Access app that automates exporting various queries to Excel, automating charts, etc.
VBA Visual Basic for Applications (Microsoft) FAQ
I have the same question Show 0 Likes 0. The program then, expecting the temp file to be where it is, sends temp. Runs best on HiVelocity Hosting. Go to original post.
Should i just dim as variant as well? There is probably a parameter to use. Additionally, in some cases, an additional Word doc is created on the fly which must also be saved as C: Results applicxtion to 10 of 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: Trying to record the Macro using toolbar buttons or dropdowns yields a macro with no code.
The default PDF file applciation will be same as the source Excel file.
I haven’t tested extensively, but I think it will work. The file type must be “.
Help finding Active printer “on Ne02”
You can not post a blank message. This used to work in the past!! The error handler looping through Ne numbers worked once I got rid of the second on error goto statement, which Excel ignored even though I had set my options to break in class modules. Thank you, in advance, for your help. This will make it execute and send the file to the location you want. Sorry, I have no idea why it doesn’t work, but do try it with a local file name.