print

Can someone please help me understand why the macro below outputs a PostScript file instead of a PDF file and if there is a way to tweak it such that it does what I expect it to do which is to print a PDF file, not a PostScript file. I would immensenly appreciate any help. Thank you...

I'm working on a project currently that requires me to sort a dataset into individual departments and print a list of products off for the department to check physical stock. Currently my sheet splits into 7 different sheets, each with a separate department list This works by sorting the "Dept...

Hello Thanks for the help in advance! I wanted to have a button on a landing page of a workbook to print a specific sheet named "leather letter" on the excel file. So basically I would like that when someone clicks that button a prompt shows up to select the location to print only that sheet...

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