application.activeprinter

Hello, everything that I can find on this is saying I have the correct code, but is still not working. I recorded the marco to select the printer, so I am assuming that is correct. Any help would be great. This is what I have; Sub CHANGE_PRINTER_ONE() Dim sCurrentPrinter As String...

Hi all, To change from Activeprinter to other printer (without showing Print Dialog), we use for example macro code: Application.ActivePrinter = "Brother HL-2170W series on Ne04:" Or Application.ActivePrinter = "HP LaserJet P2035n Design on Ne03:" In first code printer name is “ Brother...

Hi and thanks in advance! In my company I have 5 printers I know howto select as the ActivePrinter one of them Application.Dialogs(xlDialogPrinterSetup).Show But If I do not want to put as the Activeprinter one of them, I want only put the selected printer within a cell eg: RANGE("A1") I do...

Hi, I have a sheet that has multiple pictures (actually a snapshot using the camera tool from other sheets in the workbook) in a sheet. When I hit F12 and save as PDF, the PDF file looks fine. Now, I do the same thing with the macro and use ExportAsFixedFormat, all the images are stretched in...

Hi and thanks in advance If I use: Dim wActPrinter As String: wActPrinter = Application.ActivePrinter If wActPrinter ="" Then 'I can request to install one, no problem But If wActPrinter <>"" and is not connected, because for eg I am using a laptop in a Taxi and I do not have the...

Hi guys, I have a label printing to a label printer using a macro, however I dont know how to properly set this up for printing from multiple computers. Here is the scenario: 4 computers all linked to this "Network" Printer/label writer. I have this printer named different on each computer...

Hi all, I have a workbook that runs a macro to fill in a "label" which is just a separate worksheet within the workbook that is formatted to a certain label size. It also prints that "label" out to a Dymo label printer that is set up as a network printer. This all works great, except sometimes...

Good day. A workbook I have has 22 worksheets. I want pages 1&2, 3&4, 5&6, etc. to print both sides. I have a color printer on the network that is not my default printer. I made a command button that will send the workbook to the color printer. I also want it to print it duplex. This is what...