print

I have a form that has several modules that print screen to the desktop and modules that print a PDF to a determined path. I want to change that to look at a cell in the sheet so I can change between five different people and the folders they need to print to. I want to change the path to look...

Hello, I'm new here and I need help. I have a very important meeting at my company on Tuesday which can possibly give me the promotion that I have been waiting for. The thing is our CEO is going to convince stakeholders of the company about something and for that he has chosen me to accompany...

Hello- I use Excel as a prep tool for our company payroll. I have a tab for each employee. I use it for overtime calculations. On each tab, i have a section where i calculate the number of hours per week then a few columns over (but still on same tab) i have a section that calculates the...

I have been using Excel for a long time but am very new macros and would consider myself a novice at coding even. I have been trying to write a macro to basically batch print multiple documents available in web hyperlinks. I'm not even sure if what I am trying to do is within Excel's...

Hi everyone, Is there any possibilty to simply write value of range variable into cell? See my code Dim SpecifiedRange As Range Set SpecifiedRange = Application.InputBox("Označ myšou v exeli z 3D rozsah kopírovania pre 1 kartu", Type:=8) Dim Range1K As String Range1K =...

Hello everyone! I make a report (which does not depend on me, and I cannot have it done any other way) that is made up of two Excel files. In the second file I need the number of sheets to consider those that are already in the first. That is, if the first file has 2 sheets, the second file...

Hi guys. This is my first post. I created an eternal calendar in Excel. I need to come up with a loop that would feed one of the cells with a specific starting year, let Excel do its thing, and then print the results as pdf file for each year. Leap years and common years would print from...

Hi All, I have this worksheet (see below) that has multiple formatted tables. Users are able to add or remove table rows as needed. What I'm wishing for it to do via VBA is the following: Remove any empty rows from any of the tables Print the whole thing from A2 down to F...the row just after...

Good Morning, It's possible to print a Userform on Mac? I try Userform1.PrintForm but it doesn't work Thanks

Hi, Good day, I am currently working with a large dataset and am utilizing a Pivot Table to better organize the information. I was wondering if there is any way for the summarized data from the Pivot Table to be sent to a new sheet and then printed with the formatting and other adjustments...

I have a main sheet named "EntryData" that changes based on the value selected in a dropdown box named "DropDown1" located on "EntryData". I am needing to be able to print the "EntryData" sheet for each value presented in "Dropdown1" with out any user interaction other than pushing a button. Is...

I have a worksheet named 'RAG' that creates individual sheets for each student. currently I have the code below that prints each validation. However, I'm looking at a way to have option to save it as one PDF document. I will want to be able to choose file path and name at point of save. Any...

Hi All, I made a print worksheet design with checkboxes in vba excel, but I don't know how to print out a separate pdf. maybe someone can help me. Thank You Option Explicit Private Sub CheckBoxAll_Click() Dim formControl As MSForms.Control Dim cb As MSForms.CheckBox...

Hi All, I have a sheet where I would like to be able to print to PDF using a control button however it seems to bug out after the End With. I can post the original document due to workplace security unfortunately. Heres the code, any suggestions? Sub MakePDF() Dim strFilename As String Dim...

Hello Everyone . I want to print my hyperlinked all pdf file by 1 Click by using VBA.

I want to disable print for all users manually, Just print only from the macro assign button (want to use for small office billing invoices) Sub PostToRegister() Dim WS1 As worksheet Dim WS2 As worksheet Set WS1 = Worksheets("INVOICE") Set WS2 = Worksheets("DATABASE") WS2.Unprotect...

Hi guys, I need a VBA formula which can help me with PDF files PRINTING. How I thing it should be ? : 1) Excel with button ( Print ) Which print all cells with numbered files. 2) Folder include reports names : 12763-12764_AZF-CS-4004 and in excel I write only AZF-CS-4004. Is it possible to...

Hi guys, is there a way to avoid printing rows if there is no text in it? I make purchase orders that sometimes range in the hundreds of lines which would fit over multiple sheets of paper, but I would like to have just one page print my rows 18 to 35 specifically every time, and if there is...

Hello I would like to ask if and in what way it is possible to create a specific print report in excel. I need to print data from Excel in a specific format, where each cell in the column has a designated specific place in the document - from one line in Excel, make 3 on A4 in the printed...

Sub PrintAll() Dim i As Long, LastRow As Long LastRow = Worksheets("Names").Range("A65536").End(xlUp).Row For i = 1 To LastRow Worksheets("Form").Range("A1").Value = Worksheets("Names").Range("A" & i).Value Worksheets("Form").Range("Print_Me").PrintOut Next i End Sub I have...