pdf

  1. D

    Run-time error "53": File not found - How to fix?

    Hello everybody, I am currently running an excel file in which I have created an order form that people can fill out with their information and the products that they would like to order. I am using a VBA code (please let me know in the comments if you want me to attach the entire code)...
  2. B

    Print function set to Print to PDF

    Hi I have a form that I would like to have the print function defaulted to Print to PDF I also would like the person to be able to preview the print prior this is the code I presently have that allows me to preview but not sure what to add in order for it to default to "Print to PDF"...
  3. D

    Convert Excel to PDF before sending out automatically by email

    Hello Everybody, I am currently trying to create an Excel macro that converts my excel sheet into a PDF file and then sends it out by email. My current macro can do this, but it cannot convert it to a PDF file. I tried to merge my current VBA formula with the one here: to convert my excel...
  4. N

    How to set several dynamic print areas and create macro to save them in PDF format

    I am trying to automate one of my spreasheets. I have an idea but because I have never used macros before, I don't know how to do it. I have a file (Excel 2010 at the moment) "sales statements generator". On one tab it has 500 statements to various customers, one under another, (formulas in...
  5. S

    Import a pdf as image in Excel using vba

    Hi everyone. Iam using this code trying to add pdf in my sheet.My problem is that appears only the first page.Any ideas how to appear every page in pdf? Thanks in advance Sub insert_pdf_to_report() Dim ol As OLEObject Dim p As Page Set ol = ActiveSheet.OLEObjects.Add(...
  6. P

    Stuck, Need Help (please). Trying to export unstructured text from PDF to import into Excel separating/placing text into specific columns

    Hello, I'm hoping someone can help with this work project. I have experience with formulas and pivot table and am somewhat familiar with Power Query but apparently not enough for it to help me with this work project. I've been trying to find an Excel work-around for this project to simplify it...
  7. C

    Save workbook as PDF when PDF is already open

    I'm trying to save a workbook on sharepoint as a PDF (which I have working using this path \\xxxx.sharepoint.com\sites\xxxx\Shared Documents\) but when someone has the PDF open on either a network share or sharepoint I get the "document not saved" error. My question is, do I just have to wait...
  8. C

    Modifying code hat inserts Digital Signature BLock into PDF Output form Excel using VBA

    Hi all, I tried to ask from the original post by John_w, but am guessing that no one is watching that so...here goes. This code was originally posted by John_w back in 2019, and works beautifully, but had modification questions... How could this be modified to allow for two (or more) signature...
  9. A

    List Files (Specific File Type) from Folder & Sub-folders to Excel w/ VBA

    Hi Guys, Anybody knows how to list all the PDF Files from a Folder and its Sub-folders to the Excel with VBA? Thank you
  10. O

    Open PDF from listed in column A, search for text in PDF that is in adjacent cell in Column B, and return a TRUE/FALSE Value

    All, I have a problem where several invoices may have the wrong information written into them. As long as the number in Column B is inside the PDF listed in Column A, I know that it is ok. So I would like to search the file listed in column A and see if the strin listed in the corresponding row...
  11. C

    Extract Images from a PDF using VBA

    I am trying to extract images from a PDF in Excel VBA. I am able to extract all of the text page by page with no problem (code below). I have searched for sample code or an explanation of how to extract images but the only sample code I found did not work. Does anybody know how to extract images...
  12. J

    Sign a PDF from Excel VBA

    I have been searching for an answer in different forums without success, so I decided to open a post. Currently, I generate a PDF file from a range or a worksheet in Excel. What I need is to include a signature in the PDF file. This is the code that I gather from different sources to open the...
  13. P

    VBA to save some sheets as xlxs and some as PDF

    Hi, I am hoping for some help to for VBA code to save some sheets as xlxs and some as pdf. I am using the below code to save all sheets as xlxs with a filename as the name of the sheet within the workbook. Sub SaveShtsAsBook() Dim Sheet As Worksheet, SheetName$, MyFilePath$, N&...
  14. T

    PDF to excel quagmire...in theory

    I've been assign a task where I need to map data from a PDF converted excel file to another exported excel file with pre-determined headers. The goal is to standardized the converted PDF so that the data can be extracted to the exported excel file in vba. One big issue I foresee is that the...
  15. J

    VBA - Updating Sheets and Sending Email to Multiple Recipients

    I am hoping for some help on this one. Looking for a VBA wizard to direct me . I have an email list where the Name/Address/Birthday/Todays Date is noted. On sheet2 I have a generic message. I need to send an email to all of the people on the list with the generic message as a PDF. This part is...
  16. T

    VBA for Save as PDF & Save file help

    Hi Guys, I have created a VBA which saves the active sheet of the specific workbook - this works perfectly but I also want to save the whole workbook alongside the PDF with the same filename as the PDF. How can I fit this in on the same macro? Please see below code: Sub PDFActiveSheet() Dim...
  17. I

    NEED MACRO TO MOVE PDF INVOICES INTO DIVISION's MULTIPLE JOB#'s SUB-FOLDERS

    Hello Everyone, Good day I NEED MACRO TO MOVE PDF INVOICES INTO DIVISION MULTIPLE JOB#'s SUB-FOLDERS Everyone I’m new to EXCEL VBA I want to one VBA EXCEL MACRO that can move my PDF INVOICES (19361-11599-113) Files FROM SOURCE FOLDER (Y:\) into SHARED DESTINATION FOLDER (Z:\Billing...
  18. B

    use excel/outlook VBA open PDF file(password protected but have password to open it) and then click the link(on pdf file ) to open the file

    Hi All I need your Excel Excel/Outlook VBA expert to help. I knew how to build up outlook VBA to detect new email with attached file (i.e. PDF file) coming in the specific folder but have the following problem : The email has attached file that is PDF file with password...
  19. A

    PDF Attachments

    Hi All, I need to attach a series of PDF's to an Outlook item in excel. I have a command button which will open up a outlook message but I need to know how/where can I store the PDF files if I was to access the spreadsheet sung a dofferent machine that I do not have to change any folder paths...
  20. A

    VBA command to open PDF

    Hi All, my first post here :) I am trying to create an interface to select and open PDF reports from Excel. Currently I have got 4 drop down boxes where users can select which report they would like to see. Currently the options are drop down box 1 : Europe, America and Pacific drop down...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top