pdf

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

Hi, My code below currently copy/paste each row from Sheet 1 (detailsSheet) to Sheet 2 (reportSheet) and then print/save it as a PDF on my desktop, and works great! As a next step (where I would appreciate some help), I would like to copy rows as long as the value in column A is the same. For...

Hello all, It's been a long time since I've used any VBA and it's not coming back like riding a bicycle... Hoping for some help on hopefully easy task. I have a sheet with tens of thousands of rows of invoice data -- each row is a discrete invoice with various columns of information, including...

Hi, I'm trying to import pdf bank statements directly into excel on my Mac. How can this be done without paying for software such as docuclipper. Windows users seem to be able to use the Power query editor, and can also clean up the spreadsheet after conversion but this doesn't seem to be...

Hello, first post. Will appreciate any help - even just a pointer to the correct place to look. I'm struggling to word this requirement but here goes: I have a data table in excel (a proper table). Each record contains a student and several other fields of use. It also details the teacher, and...

Hi All, I know this is not necessarily Excel-related, however, it is going to be VBA related. I have created a return-to-work form in word, which is sent to managers to complete return-to-work interviews for sick employees. The document is restricted and only form fields can be completed...