print

Hi there. I've searched everywhere and couldn't find a solution for this :cry: I'm trying to export an excel workbook as a single file with the following conditions: - The first sheet shouldn't be exported - The second sheet should be in duplicated - The last sheet should be included or...

I am trying to generate printable stickers from Data I have in Excel. I currently have 4 columns of Data, Columns A and F are the values and C and H Barcodes were generated from Columns A and H: The problem I have is trying to format and mass generate printable Barcode sticker labels from...

Hi guys, I am currently working on a tool to efficiently print the logs of our production process. However, sad to say I am really stucked. Initially, my idea was to be able to select the desired .xlsx file from a directory - which I was able to do using a macro. Then...

Hi, please help me make a correct code. I have a list of links in column A, and I need to open all links then save each webpages to pdf. I am using the below code but I can only open 1 link using it by changing the Range to A2 and it doesn't print to pdf. Unfortunately, I cannot download...

Hello, I have a worksheet that collect data from various worksheets and insert them at a worksheet. I need when I press print , a text that is in another sheet to be placed at the last printed page. i.e. if the print is 3 pages then then text wil be placed at the bottom of the 3rd page. If 2...

Hello! I am working in a tool to generate reports. I have created a form in one worksheet "Report" and when a change a cell values related to the tag, this form is be populated with the information related to that tag number. I created the following code, but after the macro finish running, the...

Hey, I have a problem with exporting a range of data to an PDF file. I looked around this website but none seems to give me the solution. I am using this code to export a PDF file, which than will be attached to an email, this works perfect. ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF...

Hi guys, I need print a lot of same documents from my working folder. And those excel files has only 2 pages and I need only second page from those documents. How I can do that with VBA ? Thank you !!! Files plece in C:\Users\User\Desktop\WQT CER

Hello looking for some support and not even sure if it is possible Am looking for a way to use macro to ask the user to enter 2 dates and it will print the sheets between these dates sounds simple but am guessing not as easy to do background Am using A single workbook with each sheet named...

Hi, I'm using the below code to print files to a different printer than the default printer. But my file is always printing to the default printer, but not to the application.activeprinter Please help me to sort out the issue. Declare PtrSafe Function ShellExecute Lib "shell32.dll" Alias _...

I am trying to print ranges based on the last row number and the Listbox selection. It gets down to this line then it says the compile error wrong number of arguments??? Set Rng = ws.Range("A1:AA61", "A62:AA122", "A123:AA183") Full code: Private Sub Print_Job_Card_Click() Dim i As...

I know its a boring question and i found many questions like this one. But im unable to edit code to suit my needs... I found code here with similar problem. https://www.mrexcel.com/board/threads/auto-increment-a1-cell-after-each-printing.489157/ My situation: I have a template on first page...

In my workbook, I have several sheets which contain different forms and where the data is populated through vba program. I am able to print these forms only when the sheets are made visible, if very hidden the printing is not possible. I am adding thisworkbook.sheets("sheetname").activate...

I have a pivot table taking up a single column on a worksheet. The table contains a name and a date in the row field of the pivot table. The purpose is to summarise dates allocated to a person. When I print the table to a PDF it puts on column on each page. Is there way to spill it into 3...

Error rows going onto next page when space left on page, only seems to happen for this workbook, all others seem to fill ok. But there is a fair amount of invested time in layouts formula, and macros that would be a pain to switch to a new workbook (so i'm leaving that as last resort) Workbook...

I would like to upgrade an already answered question in a thread: Macro to populate cell and then print on loop I want to upgrade in a way that in addition to increasing a number in a cell and printing to take a value from a cell and save it with the name in the cell and also to the same time...

Hey Everyone, So I've been looking online for this, but nothing seems to work. I have a dropdown list in cell B21 in sheet named CERTDELEGATES that pulls data form another sheet, Delegates. What I need is a macro that will print all the names in that list to a single PDF in the same folder as...

Greetings Recently I have been working on a VBA that does the following while launched in a separate macro-enabled Excel file: 1. Open Workbook1 in a separate process and choses a unit in validation list (drop-down menu list, what changes data on the Sheet1) 2. Copy Sheet1 to a new workbook (in...

Hi guys i want when i select a range, after that with run a macro, doing this 3 steps Paste in a sheet that named Sheet from cell A3 after that print from a sheet that named Print after that clear contents from A3 until rows of sheet that named Sheet be ended...

I'm using this code that I found in another thread. It opens a pdf file in Adobe Reader and prints it to a PDF. It works great, however, when I run the code, it triggers a dialog window in Adobe Acrobat, where you are suppose to enter the file name and hit save. I would need it to have the file...