printing

So I had some macro code (provided by others from here and other sites) that looped through and printed many files that up until today worked just fine: <code>Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" _ (ByVal hwnd As Long, ByVal lpOperation As String, ByVal...

Hi It is my first Excel related post ever but at this stage I'm desperate. I've searched many websites and forums but can't find solution for the problem. I have Command button in sheet 1 that is responsible for copying data from table in Sheet 2, pasting in specific cells in sheet 1 and...

I have a sheet with several pivot tables, graphs, tables, headers, etc... stacked vertically. The first couple of pages of content fit on onto their own single page, however, the last Pivot Table spans 4-5 pages and to throw a wrench into things, I am using the pivot table to add long formulas...

Hi! I'm having a hard time with the way Excel scales worksheets for printing. I'm trying to create a narrative report which has 16 pages, to be printed first to a PDF using a virtual printer, and then on A4 paper using a plastic-and-circuit-boards printer. (Yes, it has to be created in Excel...

Hey all, I have this strange issue with some of my Excel files. Whenever I try to print from excel, it will lock up when selecting the "Print" section under "File." Once it's at the printer settings, it will say "Looking for printers" at the printer selection menu and the entire excel sheet...

Hi, I need to do a print specific sheets in 30 workbooks. The sheet names remain the same. I save my files in a folder and want to execute my printing from a document with a printing macro that would allow me to select the folder (or documents) and print the sheets. I have tried the following...

Hi, I have a workbook with several sheets with specific print areas. I have all protections on each sheet except for the ability to select cells. Even with these de-selected, I was able to set the print area to 1 cell. Is there any way to protect the print area designation and potentially all...

I am new to Mr. Excel, but I have found some helpful things in the past via google searching. I am hoping I can get some help directly associated with my dilemma for a personal project I am working on. I'll try to be as accurate & thorough as possible. Currently in my excel workbook I have two...

I am hoping I can get some help with this issue on here. :confused: I have researched, but to no avail. I have created a dashboard using PivotTables/PivotCharts to show trends in payroll. The Dashboard has 8 different graphs on it that are controlled with 4 different slicers. When the...

Hey everyone, I have a bit of a problem with a printing macro that I hope you guys can solve for me. Basically the macro I copied from another website fulfills most of my wishes as it prints out all chartsheets from Excel. However, it stops working because there are hidden chartsheets. I wish...

Hello, Can someone please help me and tell me what I am doing wrong? Private Sub CommandButton1_Click() Sub test() Dim rng As Range Dim wks As Worksheet For Each rng In Sheets("ToC").Range("B3:B15") If Trim(rng.Value) <> "" Then On Error Resume Next Set wks = Nothing...

Hi, folks...hoping I can find some guidance here. I've already searched the forums and didn't find an answer to this poser. So I've been tasked with creating bar codes for a scanning project. The data (document keywords) are being provided to me in an Excel spreadsheet. Each column represents...

I'm rather new to using VBA and was looking for some help. The issue I'm having currently is that we have a sheet that users input data into, then once complete there is a macro that they can use to print. The macro prints 3 copies and transfers the given data into a log. However users are...

Hello all My first post here. I'm looking for something probably very simple. I have a worksheet, name "essentials", which has 290 printable pages. I want to be able to print one page at a time from the selection of pages 1 to 290. e.g. Assign a macro to a "print" button which will then...

I have about 50 worksheets in a workbook that I want to print at the same time. Being not the wasteful type of person I naturally want to print them all in Duplex but with each worksheet on a new separate page. Each worksheet has a different amount of content so can be anywhere from 1~5 pages...

Hello everyone, This is my code. This code will grab all the files from a source folder, open each workbook, print all worksheets, and then close it. repeat. However, I am getting an error saying "Run Time Error 1004. Method "PrintOut" of object_Worksheet. failed. I think it is because there...

I have a workbook with multiple sheets, some of which are hidden. Currently I have a button on a userform with this code for printing Private Sub cmd_printfltplan_Click() Dim Printx As String Dim sCurrentPrinter As String 'Setting the current printer to the active printer sCurrentPrinter =...

Hello all, I need Excel 2013 to print to a non-default printer, here is my code Sub QuickChangePrinter() Dim sNewPrinter As String sNewPrinter = ActivePrinter ActivePrinter = "[printer name]" Application.PrintOut Filename:="[test print]" ActivePrinter = sNewPrinter End Sub When I try to run...

I have a spreadsheet that has multiple groups of rows that are sometimes hidden and sometimes not but ultimately change the number of pages and page breaks when printing. I was wondering if there is a way to write a macro that will keep groups of rows together so that they don't split across...

Hello all, I want to start by saying I'm still fairly new to VBA and proper VBA coding procedures and such. I've pieced together a few things to do what I need to do, but I'm more than open to changing any part of this process to make this work. Alright, so I've got a workbook. One of the...