printer

Excel 2016. I'll be darned if I can get 6 worksheets to print double sided except for one method. I've tried using my printer settings when using the Print function. Even if I select double sided it prints one page at a time. I even selected both tabs to be active. The only way I found this...

Hi Guys I Have an issue with he code below that i have been struggling with for a while, what i want to do is print a word document to a printer that has been selected Dim objWord Dim objDoc Set objWord = CreateObject("Word.Application") Set objDoc =...

I am looking for a VBA Code that can be used to print to a specific printer on 11x17 sheet in landscape orientation and print area based on the dynamic print area that i have already set up. I have tried recording a macro but can only get it to print to last used printer. Can anyone help?

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...

All, I am trying to figure out how to go about this. I need to add a column and if Column "E" contains the word Printer and column "D" contains "OWB", i need to display "OWB PRINTER". If it doesnt match than i can just put "OTHER Some examples below. Column "D"...

Hi, I have an Excel worksheet which is sent to several stakeholders. Some stakeholders want to print out the spreadsheet but want to be able to print it out as A3 automatically. In other words make the spreadsheet i send out as A3 printer friendly. The issue is my PC does not have a Printer...

Hi Guys. I have a workbook that has 8 worksheets that i use the code below to bring up a box that allows me to select which sheets I need to send to the printer and it has worked well. The problem I am having is when I print a different workbook or worksheet to a different printer (pdf factory...

I have a file where I need to print the pages from last to first. We're using Excel 2013 and Xerox Phaser 7500 printers. Is there a way to specify this either from the Excel print menu or from the printer options? I could do it using VBA but I'm hoping there's something more obvious. TIA

Hello everyone, how to read name of document in the printer using vba

We are using Excel for training documentation. When the person being trained completes a training session, he/she will print out the sheet for documentation that they have had the training referenced in the sheet. The person responsible for training, then files the sheet away for future...

Hello! Looking for some help on an old mdb that some friends at a local horse barn had made for them in 1997. They recently purchased new equipment for their office, and are no longer able to use their report for printing #10 envelopes in the same way that the old equipment used to. Nothing...

Hi guys, I have two files that need to print at different dimensions. The dimensions are set by the label printers. I am wondering if anyone knows how to get a file to always print to a specific printer. I looked into it and it looks as though it may be dependent on a macro. Thanks!

I need to save all sheets in a workbook using my pdf printer (Foxit PhantomPDF Printer on Ne04:), using the sheet name as the filename. I believe i need to use my pdf printer vs the Save as PDF function (see below) I was using the code below, but it seems to save the sheets in a size larger...

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...

Please can some one help me here. Some where I have seen a small piece of code that lists the printer name and the respective Ne port number on PC that runs the code but I can't find it today. Any ideas ? Thanks

Hi Excel Experts, I am trying to decipher the below mentioned formula but unable to understand the function of " Lookup(1000," !!! I know in the lookup formula it is the lookup value but the sheet i am working on is text only & in an unstructured format. It helps to categorize different...

Hi all, I have a spreadsheet that has a summary tab with a list of customer, addresses, etc., and another tab that creates invoices from the summary. I wrote a macro that cycles through the table and creates and prints invoices to the default printer. That part works fine. I am trying to add...

Hello, I had to print my big workbook with a different printer. I had to re-adjust the page setup of more than 20 pages. Except for the printer there should have been no difference (same size, orientation, ... nothing changed) Is there a way to avoid that? What is the reason? Thanks, Michel

Can anyone help me write a macro for a school project I am working on? I think I need to use a MonthName function, I'm not sure how though. The question is: Write a Macro, that will put the employee’s month of birth in column “Birth Month”, for each employee in the database. Month should be in...

I have a project I am working on for my class and I am having trouble with this question. Below I am posting the actual question, the worksheet with the database, and the worksheet where I will be placing the macro button that will bring up the input box for the user to input information. What I...