print to pdf

Hi All - I currently have a code that prints one of my worksheets to pdf just fine however, I've run into a new problem. I've now noticed that sometimes the data that needs to be printed overlaps the print areas and is either not captured or it prints in a mess across multiple pages breaking up...

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, I wonder if anyone knows how to do this? I would really appreciate some help. I did find something i think is the answer but it is very old and i have no idea how to use it. I have a macro that runs through an excel sheet, reads an address of otehr workbooks from hyperlinks in column A...

Hi, I need some help with regard to printing / saving as PDF file once my print code is executed. I have assigned the below macro to a macro button. The printing code works perfectly. However, I need the code which finishes my printing and the saves or prints only the original copy as a PDF file...

Hi I'm using Excel in Office 365 and using a spreadsheet in .xlsx format. I need to print a chart to a pdf (which I then convert to a jpg for a website). I select the chart, then try to print to Adobe pdf and I get an error "The number must be between 10 and 400. Try again by entering a...

The issue I am having is that when I export the file to a PDF using VBA I loose my company logo at the top of the pdf version of the worksheet. It for some reason will not export with the file. While when I "print to pdf" it will stay attached. I have tried doing a command so that it prints to...

Hi All, I am in need of a VBA code to open PDF files from different locations and then print to pdf and save in another location. Further explanation: - I would like to open all the pdf files in A:\BuyerDownloads\ - I would then like the opened files to be printed to PDF and saved in...

Kindly requesting your help on this topic... I have an Excel file that generates multiple Word documents. I am trying to accomplish the following: From Excel, a file dialogue opens up for users to select multiple files (Word & PDF files) All the selected files are printed/merged into a single...

Hello, I have an application to be used by basic level users of Excel. The app will produce a set of analytics on about 20 separate worksheets. Not all users will want all 20 sheets and so I need a clean method to allow each user to select which pages they would like to print and these to then...

I have the following macro that works fine but I have had some requests if its possible to have a prompt to save into a folder near the file location ? overwriting is also needed. I would like if possible the file name function to remain ? I have searched and have come up with no 100%...

I am trying to Print to PDF from a data validation list. I have a pay summary sheet that auto fills when i select the employees name from a drop down list in Cell C6. I need to be able to print off each persons pay summary without having to manually select each persons name Currently i have a...

hi, the code below, obtained by recording a macro, works like a charm (sorry it's a bit long because of all the settings). However, this syntax sends the print command to the pre-selected printer. I would like to edit the syntax so that the CutePDF printer get selected but i cannot identify...

I have a simple macro command button with the following script: Sub PrintVisibleOnly() Dim wsh As Worksheet For Each wsh In ActiveWorkbook.Worksheets If wsh.Visible = xlSheetVisible Then wsh.PrintOut End If Next wsh End Sub This macro automatically prints the selected print...

So the first part of my code creates a PDF from my sheets, then I am trying to figure out a second part where it grabs two PDF's from one folder and saves them as one PDF in a spearate folder. Sub PrintPages() ThisWorkbook.Sheets(Array("Front Page", "Last Page")).Select...

Morning, Please can someone help me with a Print to PDF Macro with a password specified from a cell. I'm really struggling with this! I have PDF Creator but any macro I try doesn;t work so far. "Dim.pdfjob as PDFCreator." is part of the problem, I only have the options "PDFCreatorOBj...

Hi All, I am a novice when it comes to excel coding. I work in a advertising/sales company as a graphic designer and the previous owner of the company created multiple excel documents so we could send out artwork proof forms to clients. One of the forms he created so we could print to pdf and...

I am trying to figure out how to write a sub that will let me take a table of values on one tab, cycle those values through the output sheet printing a report for each row and printing all resulting reports to one PDF. At the moment, my code is printing a separate PDF for each line of output...

Using Excel 2013. I have several different worksheets with varying number of pages. I'm looking to put a macro button on the different pages that I want to print-to-pdf so that all i need to do is click the button and THAT particular page prints. When it prints-to-pdf I want the pdf page to...

Hi guys, pretty new to excel and really appreciate any help/advise offered. I have a workbook with 30 worksheets referencing off a master(worksheet) for some of there data. I would like to tick a checkbox on the master(worksheet) push my print button and have all of the selected checkboxes...

Hi! I use excel 2003. I would like to ask if someone can help me with a macro to excel. I don´t know "vba code" but i know that this should be possible. I want to print a sheet normaly (in the selected printer), but i like to print it too to pdf. I can make it without a macro, but i have to...