printer

I have a project I'm working on for class. I have a workbook with two sheets, one is a database and the other is where I am submitting my answers. The database is a list of employees with that looks like this, but longer: <colgroup><col><col><col><col><col><col><col><col><col...

Hi, I have a Macro that executes commands and prints right after. Before I execute the macro, I need to go and change printer and printer settings. Is there a way use record macro option in the File Print Menu; How would I specify in printer Setting Job Type: Normal Print I have this: [CODE]...

I am using sendkeys in a rather complicated macro to autofill 4 PDF documents based on excel source data. Because I am only able to fill, reset or print and not able to save the filled in documents, I would like to use the "Microsoft Print to PDF" printer to save the filled in PDF. I have...

Hi everyone, Got a problem spreadsheet and it's been a while since I've done anything with Excel. If you pros can cast an eye over the following I would be very grateful :D I've got a large report that has exported data about printers. I have 6 sheets that are just data, with serial numbers...

I have many vba procedures which I've written over the years, several of which include print commands. I've recently started taking my laptop between offices and using different printers. What is really irritating is having to change the printer selection each time I do so - it's very easy to...

Hi all, I published the PowerBI Desktop to web to print my reports in PDF. But for the matrix visualization the print option does not show/print the color not in PDF nor printing with real printer. I tried the printer settings but did not work :-( Any solution?

Hello everyone. Excel is normally a fantastic product, and allows you to do so many things and improves the quality of your life dramatically. However, it has 2 features that, in my opinion, are absolutely BS. I'd like to hear your opinion, or if you have any other feature to propose as even...

Hello everyone, Every month I have to print multiple workbooks, each with several sheets, and since these workbooks are edited by my colleagues, each sheet often has its own Printer Preferences. I need to print the whole work book at once (so I can use the printer stapler) and that I need to...

I have a macro that sends multiple jobs to a printer based on a list. The number of jobs could be anywhere from 50 to 700 individual print jobs. I want to be able to test if the last job was completed or if there is an error on the printer before sending a job to the printer so that I can pause...

Hello, My client is having excel 2003 and XPS Data Card Printer. He needs to print 1000 copies of data-cards. But after every single print, printer gets unselected and page size also changes. So he has to manually go and change the printer to XPS and page size(as prefered by him) for every...

I have a workbook with code that hides rows when I input a number in a designated cell. The print size is set to fit the the worksheet on one page. Is it possible to have a macro that would resize the info based on what is visible on the worksheet? i.e. The more rows with data I have would...

This may sound strange but I was wondering if anyone knew of a way to pull printer / network copier print counts (black and color) from a machine via a given IP address. I am not looking for some fancy database with history etc. Just want to run something in Excel for a list of 5-10 IP...

I've searched on these forums and google and haven't been able to find anything I can get to work. I know this is pretty basic, but this is the first time I've tried printing from VBA to a network printer. I have a report that runs automatically. A macro then runs to format it into the correct...

Hello, I would like to allow a user to select a printer from the Printer dialog. Then, I will save their selection so I may use it in future steps to print to that printer. Note, I do not want the user to print to that printer after it is selected. I need to save the value of selected printer...

Hi, I'm using vba to automate printing an Excel report to PDF. The code works fine but I need to specify the default settings within the Adobe printer properties (please see screen shot below). Does anyone know how to do this? It seems to reset the default setting to 'Standard' everytime...

I am looking to use VBA to change the name of a printer. I have USB printers and each one is named the same except the copy number. For example I have PrinterXX and PrinterXX (Copy 1) and PrinterXX (Copy 2). I would like to be able rename these in code. Has anyone done this is VBA before...

Hi I have a problem with excel VBA, if a sytem does not have any printers configured, then my application should add a new printer "Microsoft office image writer" and set that as my application's active printer. Please help me with the lines of code Thankyou Sathish