pdf

I have some base code that I found on this site that will parse a PDF based on a word. I need to expand that to parse a multi-page PDF into multiple folders based on a series of words. The words and corresponding folders are on a Sheet, the code should open the Source PDF, start with page 1...

Dear all, first point: sorry for the grammar, english isn't my native language. Now my problem: I do have a Excel sheet from which a pdf is created with a macro. There's also a field for signature being added to the pdf. I would like to create 2 drop down menus in the pdf, so u can tell, which...

We are non-profit organization, which is sending the question papers of religious exam to various schools based on their enrollment of levels. We need one code, which can print/export to combined PDF based on the parameters given in the excel sheet. Please check the attached excel sheet for...

Hello, following discussion on this post: https://www.mrexcel.com/board/threads/vba-to-place-images-inside-a-pdf.1172893/#post-5704893 The code allows me to add a button with an image. But I would like to be able to use the dynamic fields of the PDF. Off the button is in the foreground...

Hello! I need help getting VBA to Merge PDF's based on the path. I've attached a photo. Column A, B, C are file paths as they currently exist. I need VBA to grab and merge all of these columns files and use the Output location in column D as the reference for the new path name and where it...

Hi all -- Trying to automate a PDF export from a spreadsheet that may contain multiple print ranges. My method right now is to save each print range as a file name and add "_PG#" after each page, and then use Acrobat to combine the pdf's into one file and delete the files with "_PG#". My code...

I have been trying to write a macro that when run will print each sheet in a selection to PDF and name each PDF the name of the sheet. For example, if I have selected Sheet 1, Sheet 2 and Sheet 3 in a workbook. I want a macro that when executed will print Sheet1 to PDF and name the PDF "Sheet...

I got this code from Chat GPT. I asked it if it could give me code to print a PDF with page breaks. But I don’t think this will do what I want it to. For context, I’ve inherited a file which prints data in certain tabs as PDFS, but a user is also to select multiple tabs, so that one PDF...

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

Hey, I want to save two different ranges into a PDF document. One range for each page. The first range is Worksheets("Data Storage").Range("$N$4:$P$20") = Range for First Page The second range is Worksheets("Data Storage").Range("$Z$32:$AG$97") = Range for Second Page (The Range in Macro...

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

Hello, I've got an issue with FIleCopy command in VBA. I always used this when i wanted to copy/paste some file from one folder to another. (but it was local or based on the server). Unfortunately at that moment i have to wokr with onedrive solution. I need to build some file (or rather wanna...

I have the following code that creates hyperlinks from all pdfs contained in a folder and listed in column N. Sub extractfiles_hyperlink() Dim xFSO As Object Dim xFolder As Object Dim xFile As Object Dim xFiDialog As FileDialog Dim xPath As String Dim i As Integer...

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.

Hi Guys, hoping for some help, couldn't find a solution browsing the forums; Have adapted some code as below which does work in theory, it creates a temp pdf from a set range, attaches it to an email and then Kills the file when complete - is there a way to rename this pdf attachment to a cell...

Hi, Apologies if this is answered elsewhere but I've searched high and low for the answer to this one and even thought I'd found it when I found a Ron De Bruin post on it so tweaked my code to align with his and still no luck. Essentially I have a workbook that runs a list through a template...

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

Hi, I am trying to create a VBA code which will generate a pdf report where multiple ranges from a sheet will be printed onto one page. In order to achieve this the ranges have to follow after each, hope that make sense.... So far this is the code I have been able to write Private Sub...

Hi - I am working on a macro that prints select sheets to a PDF output. For some reason, it will always print the first page in portrait mode even when I define in page setup to print it as landscape. If I put a page before it, that new first page will print as portrait and then my old "page 1"...