pdf

  1. D

    Export only one sheet as PDF - Save as prompt

    Hi Thanks for the help in advance on this matter. 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 with the "Save as" dialog so the...
  2. Jyggalag

    Make excel macro refer to other sheet than itself

    Hi all, I currently have this code, which saves my sheet (entitled "Sheet3") as a PDF: Option Explicit Sub SaveFileWithMacro() Dim Path As String Dim fn As String Path = "S:\Path\PDF files\" fn = Range("A63") ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=Path & fn & ".pdf" End...
  3. Jyggalag

    Save excel sheet as PDF (only one sheet)

    Hi all, I currently have a macro that converts my excel sheet into a PDF and saves it in a designated folder. However, I only want it to save the first sheet as a PDF, and ignore my other sheets, which it will not do at the moment. My code looks as follows: Option Explicit Sub...
  4. D

    Export only one sheet as PDF

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

    Printing Workbook as PDF

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

    VBA, Print The Sheets That Were Selected in the UserForm into 1 PDF

    Hi everyone, I am trying to make a userform where each sheet has its own corresponding checkbox. The goal is to print the selected sheets into a pdf upon clicking OK button. I have managed to somewhat achieve my goal. But it feels like it is far from being optimal. I had to assign 2...
  7. J

    Save as PDF & Specified File name based on cell

    Hi, Looking to use a Macro in excel that saves document as PDF but the file name needs to be: Cashing Up Week End (Cell N4) which is a date Hope someone can help! Thanks
  8. T

    PDF Printing is slow

    I have a macro that prints several pdf's for schedules from one sheet. It takes about 10 minutes for the macro to run and make the 10 pdf's. Is there a way to make this run faster? Sub Create_Schedules() Sheet1.Activate ActiveWindow.View = xlPageBreakPreview Dim Yellow As String Yellow =...
  9. S

    Need help on Insert PDF file VBA function

    Dear Members, I am using the following code to display photo from a folder in my excel sheet. Sub DisplayMainPicture() With Sheet1 On Error Resume Next .Shapes("ReceiptPic").Delete On Error GoTo 0 If .Range("I12").Value = Empty Then Exit Sub PicPath = .Range("I12").Value 'Picture Path If...
  10. J

    Power Query - Skipping Files Exceeding 400 Character Limit

    I have a successful route of pulling information from a collection of PDF files (with structured tables) that are located on a Network Drive. I am now running into an issue where the Power Query refresh stops when it finds a PDF file with a full Path/File Name that exceeds the Microsoft Office...
  11. Y

    PDF To Excel

    Hello, I'm pretty new in Excel VBA so I don't know much about it. Basically I want to create a tool which can take PDF files from the folder in which the excel sheet is saved and paste them in Excel rows, Like if there are 4 PDF Files in my folder then I want the tool paste all of them in...
  12. Jyggalag

    Macro to save file as PDF saves full sheet

    Hi all, I have this overview at the moment: If I manually choose to save my file as a PDF, it works fine and I get just 1 page with the overview above. However, I have the following VBA code to save my file as a PDF: Option Explicit Sub SaveFileWithMacro() Dim Path As String Dim fn As...
  13. J

    Curious problem, excel creates a PDF (with data), then when sending as attachment, PDF is BLANK

    I have tried to search and can't find anyone reporting a similar question/problem. I have a macro that filters some data, and then creates a PDF file from the filtered data, so far no problem. Then I have a macro that then sends the PDF file as an attachment in an email, but the problem is...
  14. T

    PDF Drawings to Excel format

    Hi guys, I want ask from you about one thing which came into my mind and take some recommendations about it. I have a lot of PDF drawings which I should check and count the type and total Amount of Joints. The whole process which I want to automate I will write below Step By step: All job...
  15. A

    Macro that creates a word document (and then a PDF) very slow

    Hello MrExcel, I have a macro that essentially exports text in 3 columns into a word document before converting to a PDF. I have had to do this as the text in 1 of the columns is well over 300 characters and can't be done in excel. Unfortunately when i run the macro it takes about 13 minutes...
  16. M

    Save to PDF multiple sheets (header, main sheet, footer)

    Hello everyone! I have found a lot of help reading these forums (Google search results) and learned quite a bit. I am no expert and have an issue. I have a workbook with several sheets that combine results into one final sheet - a purchase order. Since this sheet is dynamic and can include...
  17. Jyggalag

    Change my VBA code so it sends pdf file instead of excel file

    Hi all, I currently have this VBA code: Option Explicit Private Const FilePath As String = "S:\COMPANY\FOLDER OF COMPANY\FOLDER 15\TEST FOLDER\Attachments\" Sub send_email_complete() Dim OutApp As Object Dim OutMail As Object Dim i As Long Dim ws As Worksheet Dim col As...
  18. T

    Merge PDFs using VBA

    I have the following scenario: I have up to 200 different folders on my desktop. In each of these folders, I have up to 15 different pdf files. So I might have the following: Folder A: Maths.pdf , English.pdf , Science.pdf , Geography.pdf Folder B: Maths.pdf , English.pdf , Geography.pdf...
  19. N

    Merge PDFs Button based on filtered list

    Hi, I'm basically looking for a method to merged all filtered .pdfs based on "work pack" column into one pdf using the button shown, see image attached. Is this even possible? I've seen methods using Acrobat Pro which I do not own. If when I click the button, it generates a merged pdf file...
  20. Jyggalag

    Send out email through VBA and Macro in Outlook

    Dear all, (Please note that I am using the Outlook program in Windows). I currently have a setup that looks approximately like this (please ignore the snippet on the right side, it is purely to show what an email looks like in an outlook format): I was wondering if it would be possible to...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top