pdf

Totally confounded by this error. Sub has been working perfectly for some time and today stopped working out of the blue. Error code is 1004 - "Method "ExportAsFixedFormatType" of object _Worksheet failed." The sub takes a worksheet as a parameter then exports it to a pdf in a specific folder...

Hi, I have been given a new task as I'm the most IT literate in the office. I've done a small bit of VERY basic VB coding/Macros. I've stumbled across a code here and wanted to know how I could edit it and implement it to work for my use case. I need to: Export a PDF to the same location...

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

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